Sort dbt Layers By Responsibility

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

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

Already have an account? Sign in