dbt Architecture

소개

This skill transforms Claude into an expert dbt architect, providing comprehensive guidance on implementing the medallion architecture (bronze, silver, and gold layers) for data modeling. It offers standardized naming conventions, folder structures, and configuration strategies that ensure data integrity and scalability across the data pipeline. Whether you are planning a new project from scratch or refactoring an existing one, this resource helps enforce industry best practices like one-to-one staging, proper layer separation, and efficient materialization strategies to build reliable, production-ready data products.

주요 기능

• 23 GitHub stars
• Production-grade folder organization and structural guidance
• Folder-level configuration strategies for dbt_project.yml to reduce repetition
• Medallion architecture implementation patterns for bronze, silver, and gold layers
• Standardized naming conventions for models (stg, int, dim, fct) and columns
• Best practices for model dependencies, materialization, and tag inheritance

사용 사례

• Refactoring existing transformations into distinct architectural layers for better maintainability
• Planning the initial folder structure and organization for a new production dbt project
• Establishing consistent naming conventions for models and columns across a data team