Royal Civic Teal admin experience
Operational control surface
?
...
unknown
Model catalogue
/
Admin / dbt Studio / Models
stg_complaints
Open in Studio
SJ
Stale
Compile
Test
Run
SQL
Compiled
Lineage
Docs
Preview
models/staging/stg_complaints.sql
Copy
{{ config(materialized='view') }} with source as ( select * from {{ source('raw_airbyte', 'src_municipal_complaints') }} ) select complaint_id, district_id::integer as district_id, lower(trim(category)) as category, lower(trim(status)) as status, _landed_at::timestamp as _landed_at from source where complaint_id is not null
Console
Clear
-- stg_complaints · open in dbt Studio