unit_test_view.sql

config {
  type: "test",
  dataset: "reputation_data_v"
}
-- use input to mock some test data for production.reputation_data table used by the view:
input "reputation_data" {
    select
  '{"user_id":1,"reputation_level":3.5,"updated_at":"1999-01-01 00:00:01 UTC"}' as src
}
-- run the view and we expect to get:
select
     1   as user_id
    ,3.5 as reputation_level
    ,timestamp('1999-01-01 00:00:01 UTC') as updated_at
;