Can it help me fix failing dbt tests?

Absolutely. It analyzes the specific failure reason—such as duplicate records for a unique test or unexpected NULLs—and suggests SQL fixes or model adjustments to resolve the data issue.

Which tests are recommended for primary keys?

Following dbt best practices, the skill consistently recommends applying both 'unique' and 'not_null' tests to all columns identified as primary keys.

Does it support custom dbt packages?

Yes, it can identify and implement tests from common community packages like dbt_utils and dbt_expectations if they are already present in your packages.yml file.

How does this skill handle existing project styles?

The skill first scans your existing schema.yml files to detect indentation, spacing, and naming conventions to ensure all new tests match your project's specific aesthetic and standards.

dbt Model Testing & Quality

Name: dbt Model Testing & Quality
Author: AltimateAI

byAltimateAI

•

보안 및 테스팅

Implements comprehensive data quality validation and schema testing for dbt models while maintaining project-specific coding standards.

This skill empowers Claude to automate the critical task of data validation within dbt (data build tool) projects. It systematically analyzes existing schema patterns to ensure new tests match current YAML formatting and indentation styles. By identifying primary keys, foreign keys, and business-critical columns, the skill helps implement standard generic tests like unique and not_null, as well as complex relationship and custom tests. It is an essential tool for data engineers looking to maintain high data integrity, debug test failures efficiently, and enforce best practices across their data transformation pipelines.

주요 기능

01Step-by-step troubleshooting for failing unique, not_null, and relationship tests

02Automated schema.yml test generation for primary and foreign keys

03Support for singular SQL tests and business logic validation

04Style-matching engine to maintain consistent YAML formatting and indentation

05Integration with dbt packages like dbt_utils and dbt_expectations

0655 GitHub stars

사용 사례

01Refactoring data models while ensuring no regressions in data quality

02Adding mandatory integrity constraints to new dbt models before deployment

03Auditing existing models to find and fix missing primary key validations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add altimateai/data-engineering-skills dbt

For use in Claude.ai and ChatGPT

Download Skill