Skip to main content

Stage Raw Tables Before You Join

Explain why staging models should clean raw tables before marts join them.

dbt-basics5 min read

A staging model is the adapter between messy source reality and stable analytics language. The mechanism Staging models should be thin, boring, and close to the source. They rename columns, cast data types, standardize booleans and timestamps, and preserve grain. They should not answer business questions yet. This separation works because marts can depend on a stable vocabulary instead of every downstream model rediscovering raw quirks. Common trap The tempting shortcut is to join raw orders, raw customers, and raw payments directly in the final revenue model. It feels faster until a raw field changes, a dashboard breaks, and no…

Read the full lesson

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

← Back to library

Contact us