[Verse 1]
Raw data scattered like autumn leaves
Tables tangled, no one believes
This mess could tell a story true
Enter dbt to see us through
SQL transforms with just a push
Version control keeps chaos hushed
[Chorus]
Build and test, transform with zest
dbt makes your data blessed
Models flow from source to mart
Analytics ready, that's the art
Build and test, transform with zest
Raw becomes refined and blessed
[Verse 2]
Models sit in folders neat
Each one makes your pipeline complete
Dependencies mapped like family trees
Parent tables, children keys
Run commands and watch them grow
From bronze to silver, then to gold
[Chorus]
Build and test, transform with zest
dbt makes your data blessed
Models flow from source to mart
Analytics ready, that's the art
Build and test, transform with zest
Raw becomes refined and blessed
[Bridge]
Git commits track every change
Documentation's in your range
Testing hooks catch bugs before
Analysts come knocking at your door
Macros help you stay DRY
Don't repeat, just modify
[Verse 3]
Seeds and snapshots capture time
Freshness tests keep data prime
Staging layers clean the grime
Production models shine sublime
Lineage graphs show the flow
Every transformation you will know
[Chorus]
Build and test, transform with zest
dbt makes your data blessed
Models flow from source to mart
Analytics ready, that's the art
Build and test, transform with zest
Raw becomes refined and blessed
[Outro]
From warehouse mess to dashboard gold
dbt's the story to be told
SQL plus git equals might
Making data analysts' delight