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
    On this page

    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.

    — Ari Bajo, Founder of toolsfordata.com

    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.