The problem it solves
dbt unit tests are powerful but often skipped because writing mock inputs, expected outputs, and edge cases takes time and careful model understanding.
What it does
Analyzes SQL logic such as joins, CASE statements, null handling, windows, and incremental behavior.
Finds upstream dependencies that need mock inputs.
Generates type-aware dbt unit test YAML scaffolds.
Supports iterative refinement and validation of generated tests.
When to use it
WHEN
adding coverage for a business-critical dbt model
WHEN
a model contains logic that could silently regress
DURING
test-driven development in dbt
BEFORE
refactoring model SQL
How it works
The skill reads model SQL and manifest context, identifies testable logic, generates scenarios, refines expected outputs, and validates the tests when possible.
Put This Skill to Work. On Your Own dbt Project.
Install Altimate Code, connect your warehouse and call the skill from your terminal or your IDE. Book a demo to see it run on a project like yours.
