dbt tests

Visit Website

Introduction

dbt lets data teams transform data with software engineering practices, and testing is built in. Data tests are assertions on models: generic tests such as unique, not_null, accepted_values and relationships are declared in YAML, and singular tests are SQL queries that return failing rows.

Unit tests check model logic on static inputs before building. dbt test runs tests, and dbt build runs models and tests in order so failures stop downstream builds. The README notes that main now contains dbt v2.0, a ground-up rewrite in Rust under Apache-2.0, while v1 continues on the 1.latest branch.

In the quality loop dbt tests gate data pipelines.

The source code is at dbt-labs/dbt on GitHub under the Apache-2.0 licence, with about 14,100 stars; the most recent commit was on 11 November 2026.

Features

1. Generic data tests: unique, not_null, accepted_values, relationships.
2. Singular tests: Custom SQL checks.
3. Unit tests: Static input checks.
4. dbt build: Models and tests in DAG order.
5. Severity: Warn or error.
6. Packages: Extra tests from packages.

Pros

1. Built in: No extra tool for basic data tests.
2. Free to use: Open source under the Apache-2.0 licence, so the core tool costs nothing to use.
3. Actively maintained: The repository had commits as recent as 11 November 2026.
4. Community: About 14,100 GitHub stars.

Cons

1. Warehouse cost: Tests run queries.
2. dbt-specific: Only for dbt projects.
3. v2 transition: Rust rewrite changes tooling.

Usage and Links (Example)

models:
  - name: orders
    columns:
      - name: order_id
        data_tests: [unique, not_null]
      - name: status
        data_tests:
          - accepted_values:
              arguments: { values: ['placed','shipped','returned'] }

Resources:

• dbt tests website
• GitHub repository

Pricing

dbt tests is free and open source under the Apache-2.0 licence.

Recommended for?

1. Analytics engineers using dbt.

Conclusion

dbt tests are the first line of defence for data models.

Add unit tests for complex logic.

On CheckOps, dbt tests is filed under the Unit testing and Release & CI gates stages. Related tools listed here include pgTAP, utPLSQL, SQLFluff, Atlas, Squawk and Database Lab Engine. Which one fits best depends mostly on your stack, your team’s size and skills, and whether you prefer to run tools yourself or pay for a managed service. This page reflects the official website, documentation and repository as they stood on 11 November 2026.