Skip to content
Automatizav1
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.