Adding Dbt Unit Test

This handles the YAML scaffolding for dbt unit tests, mocking upstream inputs and defining expected outputs for your models. It's designed for test-driven development workflows where you want to validate SQL logic before materializing anything in production. The skill comes directly from dbt Labs and includes comprehensive reference docs for different warehouse-specific quirks (BigQuery, Snowflake, Redshift, etc.) plus guidance on testing incremental models and ephemeral dependencies. One thing to note: you'll need upstream models to exist in your warehouse before running unit tests standalone, though the docs explain how to use the empty flag to create schema-only versions cheaply. Best suited for testing complex SQL logic like window functions, date math, or gnarly case statements where you want confidence before deploying.

Install to Claude Code

npx -y skills add dbt-labs/dbt-agent-skills --skill adding-dbt-unit-test --agent claude-code