dbt tests
Everything you need to evaluate dbt tests for data testing: what it is, my review, pricing, features and the best alternatives.
By Ari Bajo - data engineer turned writer.
Updated on November 13, 2026
- Product
- dbt tests
- Category
- Platform-native data quality
- Pricing
- Free, open source
What is dbt tests?
dbt tests are data tests built into open-source dbt Core: generic tests (unique, not_null, accepted_values, relationships), custom SQL tests, and unit tests that run with dbt test, extended by packages like dbt-utils and dbt-expectations. They're used to check data where dbt teams already work.
dbt tests review
dbt tests are the best open-source data testing tool for dbt teams starting with data quality, since tests live next to the models and run in the same CI/CD.
Strengths
- Free, and already there if you use dbt.
- Tests live next to the models and run in the same dbt build and CI.
- Packages such as dbt-utils and dbt-expectations add more generic tests.
Caveats
- Only tests models and declared sources in your dbt project.
- No anomaly detection: thresholds are fixed values you set.
- In dbt Core, results stay in run logs and artifacts, with no dashboard or alerts.
dbt tests pricing
dbt tests are free in open-source dbt Core under Apache 2.0. The paid dbt platform runs the same tests on a schedule with a UI, but you don't need it to use them.
dbt tests features
dbt tests appears in my lists of the best data testing and open-source tools. It isn't in the feature matrix, so this page covers what it does on each list.
dbt tests data testing
Generic tests (unique, not_null, accepted_values, relationships) and custom SQL tests are SELECTs that return failing rows, plus unit tests on model logic, run with dbt test.
Compare: data testing tools
dbt tests open source
dbt tests are part of open-source dbt Core under Apache 2.0, maintained by dbt Labs. The paid dbt platform adds hosted runs and a UI, but tests work the same in Core.
Compare: open-source tools
dbt tests deployment options
dbt tests run wherever dbt Core runs, locally, in CI or from an orchestrator, on your warehouse's compute.
dbt tests alternatives
The closest dbt tests alternatives and most popular competitors are Elementary OSS, Soda Core, Great Expectations, Recce, Data Contract CLI and Elementary Cloud. They share dbt tests' main use cases and features, from the closest match down, and each one says when to consider it instead.
Add Elementary OSS for anomaly detection and a report on top of dbt tests. For data diffs on pull requests, consider Recce; for contracts shared outside dbt, Data Contract CLI.
dbt tests FAQ
Is dbt tests open source?
Yes. dbt tests are part of open-source dbt Core under Apache 2.0, maintained by dbt Labs. The paid dbt platform adds hosted runs and a UI, but tests work the same in Core.
How much does dbt tests cost?
dbt tests are free in open-source dbt Core under Apache 2.0. The paid dbt platform runs the same tests on a schedule with a UI, but you don't need it to use them.
Can dbt tests be deployed on-premise?
dbt tests run wherever dbt Core runs, locally, in CI or from an orchestrator, on your warehouse's compute.
What are the best dbt tests alternatives and competitors?
The closest alternatives are Elementary OSS, Soda Core, Great Expectations, Recce, Data Contract CLI and Elementary Cloud. The Alternatives section above says when to consider each one over dbt tests.
Browse all 102 tool profiles, grouped by category.
Evaluating data tools in 2026?
I curate the most comprehensive lists of data tools, up-to-date comparison tables, and actionable market guides for data teams. More useful than a Gartner report. More reliable than asking AI. Next up: Data FinOps.