testing-dbt-models

What problem does it solve?

dbt models can silently degrade as sources change, breaking downstream analytics and pipelines without early warning, so you need reliable schema tests that match your project’s existing conventions.

Core Features & Use Cases

• What it does: Adds and updates schema.yml tests for data integrity, including key uniqueness, required fields, allowed values, and inter-model relationships.
• Where to use it: Modifying schema.yml when you add or change dbt models, when test failures occur, and when you need to validate primary/foreign key logic and categorical fields.
• How it prevents regressions: Encourages matching the repository’s current YAML formatting, test coverage depth, custom test usage, and severity conventions.

Quick Start

Ask the agent to review the model SQL and existing schema.yml patterns, then propose the exact YAML tests to add for primary keys, foreign keys, required fields, and accepted categorical values before running dbt test for the selected model.