Royal Civic Teal admin experience
Operational control surface
?
...
unknown
Model catalogue
/
Admin / dbt Studio / Models
fct_kpi_actuals
Open in Studio
SJ
Stale
last run 2025-07-01 02:00
· 17,765 rows
Compile
Test
Run
SQL
Compiled
Lineage
Docs
Preview
models/gold/fct_kpi_actuals.sql
Copy
{{ config(materialized='incremental', unique_key='sk', schema='gold') }} select md5(district_id::text || period || kpi_code) as sk, district_name, district_id, period, kpi_code, actual_value, target_value, current_timestamp as _built_at from {{ ref('int_kpi_actuals') }} {% if is_incremental() %} where period >= (select max(period) from {{ this }}) {% endif %}
Console
Clear
-- fct_kpi_actuals · open in dbt Studio