dbt™️ tests are SQL-based assertions used to validate data models, sources, and snapshots, ensuring high data quality and integrity. By running dbt™️ test, these tests catch anomalies like nulls, duplicates, or breaking business logic, preventing downstream failures. They include built-in, generic tests (YAML) and custom singular tests (SQL).

We have created a comprehensive database of dbt™️ tests across various packages popular in the dbt™️ community today.