dbt Development

To validate dbt models against coding conventions, this skill checks naming, directory structure, CTE usage, and references to ensure consistent structure and quality. It enforces project-specific conventions when present and reports actionable guidance for fixes.

Sqlfluff integration supports dbt model linting by analyzing SQL structure and CTE usage. The validation process checks model references and applies project-specific conventions to return a compliance report with recommended fixes.

To enforce testing coverage in dbt schema.yml files, this skill validates documentation for key models and checks test definitions. It ensures compliance during model creation, refactoring, and code reviews across staging, integration, and warehouse layers.

Yes, you can use this skill to check dbt model naming and directory structure. It validates singular entities and ensures correct layer placement for staging, integration, or warehouse models, applying default or project-specific conventions.

You should run dbt model validation when creating, reviewing, or refactoring models. The skill analyzes current models against coding conventions during code reviews to enforce standards and returns actionable feedback for fixes.