[Verse 1]
Your data's raw and messy, scattered all around
Tables full of chaos, insights can't be found
You need a transformation tool to make it clean
That's where dbt comes in, the best you've ever seen
[Chorus]
dbt makes it simple, Transform and Test
Models in SQL, giving you the best
Select Transform Load, but done the modern way
Clean reliable datasets, every single day
D-B-T, your analytics friend
Transform your data from beginning to end
[Verse 2]
Start with models folder, write your SQL code
Each file is a model, on the transformation road
Raw tables become staging, then into marts they flow
Documentation built-in, so everyone can know
[Chorus]
dbt makes it simple, Transform and Test
Models in SQL, giving you the best
Select Transform Load, but done the modern way
Clean reliable datasets, every single day
D-B-T, your analytics friend
Transform your data from beginning to end
[Bridge]
Tests keep data quality high
Unique not null, no need to cry
Freshness checks and custom rules
dbt gives you all the tools
Version control your data code
Dependencies in the right mode
[Verse 3]
Run dbt run to build your models
dbt test to catch the problems
Lineage graphs show data flow
From source to mart, watch it grow
[Chorus]
dbt makes it simple, Transform and Test
Models in SQL, giving you the best
Select Transform Load, but done the modern way
Clean reliable datasets, every single day
D-B-T, your analytics friend
Transform your data from beginning to end
[Outro]
Raw data in, insights out
That's what transformation's all about
With dbt your data's clean and bright
Analytics done right