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.
Already have an account? Sign in