[Verse 1]
Models folder holds our treasure chest
SQL files with dot sql blessed
Each one transforms raw data streams
Into analytics teams' bright dreams
Start with sources, staging clean
Then mart layers, crisp and lean
[Chorus]
Build it up with dbt magic
Models, tests, and docs dramatic
Table, view, or incremental
Materialization's essential
Compile, run, and test it true
Data pipeline pushing through
[Verse 2]
Config blocks define the way
Materialized each model stays
Table copies all the rows
View just stores the query's prose
Incremental adds what's new
Since the last time pipeline flew
[Chorus]
Build it up with dbt magic
Models, tests, and docs dramatic
Table, view, or incremental
Materialization's essential
Compile, run, and test it true
Data pipeline pushing through
[Bridge]
References link them in a chain
Upstream feeding data grain
Dependencies flow like rivers bend
Each model waits for upstream's end
Macros wrap your logic tight
Jinja templates burning bright
[Verse 3]
Staging strips the messy parts
Intermediate models start
Calculations getting complex
Marts deliver final specs
Folders mirror business domains
Architecture that maintains
[Chorus]
Build it up with dbt magic
Models, tests, and docs dramatic
Table, view, or incremental
Materialization's essential
Compile, run, and test it true
Data pipeline pushing through
[Outro]
Transform raw into refined gold
Analytics stories to be told
Schema changes, tests will catch
Lineage graphs help us match
Dbt models pave the lane
From chaos into insight's reign