[Verse 1]
Your data pipeline's flowing strong
But how do you know nothing's wrong?
Raw numbers tell a risky tale
Without some tests, your insights fail
DBT can be your guide
To check your data source and side
Before you trust what numbers show
You need to test and really know
[Chorus]
Test your schema, test your data
Make sure nothing's getting badder
Unique, not null, check every row
Quality first before you go
DBT tests will save the day
Keep the dirty data away
Schema tests and data tests
Quality control at its best
[Verse 2]
Schema tests are built right in
They check your columns, thick and thin
Unique means no duplicates found
Not null ensures your data's sound
Accepted values in a list
Makes sure no categories missed
Relationships between your tables
Keep your joins reliable and stable
[Chorus]
Test your schema, test your data
Make sure nothing's getting badder
Unique, not null, check every row
Quality first before you go
DBT tests will save the day
Keep the dirty data away
Schema tests and data tests
Quality control at its best
[Bridge]
Custom data tests you can write
SQL queries check if values are right
Revenue should never be negative
Dates should be consecutive
Write your logic, make it clear
Test the things that you most fear
Automated checks will run each time
Keep your analytics in line
[Verse 3]
In your YAML file define
Which columns need to pass the line
Configure tests for every model
Keep your data quality throttle
When tests fail the build will stop
No bad data at the top
Reliable analytics start
With testing as the beating heart
[Chorus]
Test your schema, test your data
Make sure nothing's getting badder
Unique, not null, check every row
Quality first before you go
DBT tests will save the day
Keep the dirty data away
Schema tests and data tests
Quality control at its best
[Outro]
Trust your dashboard, trust your metric
DBT tests make data authentic
Quality first from source to mart
Testing is the beating heart