Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practicing…
Add unit test for a dbt model
Additional Resources
Spec Reference - All required and optional YAML keys for unit tests
Examples - Unit test examples across formats (dict, csv, sql)
Incremental Models - Unit testing incremental models
Ephemeral Dependencies - Unit testing models depending on ephemeral models
Special Case Overrides - Introspective macros, project variables, environment variables
Versioned Models - Unit testing versioned SQL models
BigQuery Caveats - BigQuery-specific caveats
BigQuery Data Types - BigQuery data type handling
Postgres Data Types - Postgres data type handling
Redshift Caveats - Redshift-specific caveats
Redshift Data Types - Redshift data type handling
Snowflake Data Types - Snowflake data type handling
Spark Data Types - Spark data type handling
What are unit tests in dbt
related skills
semantically similar in the cross-vendor index
don't have the plugin yet? install it then click "run inline in claude" again.
+comprehensive cross-warehouse coverage (bigquery, postgres, redshift, snowflake, spark) with explicit data type handling
+includes niche scenarios like ephemeral dependencies, incremental models, and versioned models
weaknesses
~no intent, inputs, or output contract defined; reads as a link collection rather than a skill with executable procedure
~zero step-by-step guidance or worked examples; defers entirely to external references without synthesizing a teachable workflow
~missing failure modes, validation checks, or recovery paths; purely happy-path reference material