rep_data_v.sql

config {
  type: "view",
  name: "reputation_data_v",
  schema: "production",
  dependencies: "reputation_data",
  tags: ["reputation_data"]
}

select 
     cast(json_extract(src,'$.user_id') as int64)                as user_id          
    ,cast(json_extract(src,'$.reputation_level') as float64)     as reputation_level 
    ,cast(json_extract_scalar(src, '$.updated_at') as timestamp) as updated_at       
from
    ${ref("reputation_data")} --production.reputation_data