dbt-testing
CommunityMaster dbt testing with database-enforced data quality.
Authorsfc-gh-dflippo
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill eliminates data quality issues by implementing comprehensive testing strategies that enforce constraints at the database level, not just during dbt runs.
Core Features & Use Cases
- Database-Level Constraints: Use dbt_constraints package for 24/7 enforcement of primary keys, foreign keys, and unique constraints.
- Layered Testing Approach: Implement appropriate tests for bronze (staging), silver (intermediate), and gold (marts) layers.
- Use Case: When building a customer analytics pipeline, use this Skill to ensure all customer IDs are unique, orders reference valid customers, and business metrics follow expected ranges.
Quick Start
Use the dbt-testing skill to create primary key constraints for my customer dimension table using dbt_constraints.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: dbt-testing Download link: https://github.com/sfc-gh-dflippo/snowflake-dbt-demo/archive/main.zip#dbt-testing Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.