Deploy fearlessly with routine testing and CI/CD
Trust is sensitive - it builds slowly, and can be erased quickly.
Data practitioners understand this more than most.
dbt enables data teams to deploy with the same confidence of software engineers, with rapid, reliable testing and CI/CD.
Teams using dbt typically verify data quality at four stages:
Use schema tests to verify raw data quality.
Avoid fan-outs or missed joins in your staging models.
Enable CI on dbt Cloud to execute tests against new PRs.
dbt Cloud offers email and Slack notifications when tests fail.
dbt makes simple testing easy, and complex testing possible.
Define data test failure conditions via plain SQL SELECT statements.
Useful for defining accepted ranges (ex: refunds must have a negative value).
This extends to statistical & distribution tests, or aggregate function tests - anything that can be written in SQL can be tested in dbt.
Avoid shipping low-quality analytics code, by validating every pull request prior to deployment.
Each CI run builds your dbt project to a temporary schema in your warehouse.