dbt tests
dbt schema and data tests
Judgement: Situational
Right when your transformations already live in dbt; otherwise reach for a standalone DQ tool.
The schema-test and data-test surface inside a dbt project — `tests:` blocks in schema.yml, generic and singular tests, and the test results that downstream tools (Elementary, dbt-osmosis, dbt artifacts) consume.
Treated as a separate entry from dbt itself because the test surface is the part of dbt that data-quality tooling interoperates with. Adopt-grade if your transformations live in dbt; situational elsewhere because the tests can't easily be lifted out of a dbt project.
Why it counts as a standard
dbt's test definitions and the manifest entries they produce are what other DQ tools (Elementary, re_data, dbt-osmosis) read. The format is the standard surface even though dbt Labs governs it.
At a glance
- Category
- Data Quality
- Governance
- dbt Labs (vendor-driven open source)
- Status
- De-facto for analytics teams already on dbt
- First released
- 2016
Links
Related standards
Other standards in Data Quality.
- Great Expectations
- SodaCL — Soda Checks Language
See dbt tests in context
Open the interactive Data Landscape to compare dbt tests against every other open standard, or grab the raw JSON. Spotted something wrong? Open an issue.