dbt Modeling

Purpose

Transform AI agents into experts on writing production-quality dbt models, providing guidance on CTE patterns, SQL structure, and best practices for creating maintainable and performant data models across all medallion architecture layers.

When to Use This Skill

Activate this skill when users ask about:

• Writing or refactoring dbt models
• Implementing CTE (Common Table Expression) patterns
• Creating staging, intermediate, or mart models
• Structuring SQL for readability and maintainability
• Implementing proper model dependencies with ref() and source()
• Converting existing SQL to dbt model format
• Debugging model SQL structure issues