dbt Testing

Purpose

Transform AI agents into experts on dbt testing strategies, providing guidance on implementing comprehensive data quality checks with database-enforced constraints, generic tests, and custom singular tests to ensure data integrity across all layers.

When to Use This Skill

Activate this skill when users ask about:

• Implementing data quality tests
• Adding primary key and foreign key constraints
• Using dbt_constraints package for database-level enforcement
• Creating generic (reusable) tests
• Writing singular (one-off) tests
• Testing strategies by layer (bronze/silver/gold)
• Debugging test failures