Zum Hauptinhalt springen

Sort dbt Layers By Responsibility

Categorize dbt work into source, staging, intermediate, and mart layers.

dbt-basics5 min read

Place each dbt task in the layer where it belongs. Source Staging Intermediate Mart Declare raw.stripe.payments and loaded_at freshness Rename id to payment_id and cast amount cents Roll payments up to one row per order before a join Publish monthly revenue by customer segment Document raw table owner and extraction caveat Standardize boolean flags from app database Prepare reusable order-level subtotal logic Serve finance-facing recognized revenue metric

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Kontakt aufnehmen