Multi-Step Pipelines

Real dbt projects chain many models: raw data feeds staging models, staging feeds intermediate joins, and intermediates feed mart-level fact and dimension tables. dbt walks the DAG and runs each layer in order.

In this lesson you will build an intermediate model that joins stg_customers with stg_orders, then a mart model that aggregates revenue per customer.