CONNECTOR · DBT
dbt — Our default transformation framework. Tests + docs as code; metric layer where appropriate.
CONNECTOR · DBT
dbt
Our default transformation framework. Tests + docs as code; metric layer where appropriate.
- categoryTransform · Modeling
- freshness targetCron-driven on Airflow / Dagster. Per-model freshness contract.
- auth modeldbt service role per environment with minimum privilege.
- sync modedbt build on PR; dbt run on schedule; dbt test mandatory.
TABLES SYNCED
Staging / intermediate / marts. Snapshots on slowly-changing dimensions.
SCHEMA · SAMPLE
schema.sqlSQL
0
{{ config(materialized= 1 ) }}
SELECT period, SUM(amount) / 100.0 AS revenue
FROM {{ ref( 2 ) }}
WHERE status = 3
{% if is_incremental() %}
AND order_ts >= (SELECT max(order_ts) FROM {{ this }})
{% endif %}
GROUP BY 1;QUERY · SAMPLE
query.sqlSQL
dbt build 0 OPS NOTES
Contract tests on marts: breaking changes fail CI. Exposure tracking links every dashboard back to the source model.
Wire a real pipeline to your warehouse
30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.