dbt Modeling

소개

Streamline your data engineering workflow by applying professional dbt modeling standards across all architecture layers. This skill provides expert guidance on structuring SQL with readable CTE patterns, implementing proper model dependencies using ref() and source() functions, and selecting optimal materialization strategies. Whether building staging models (Bronze), reusable intermediate logic (Silver), or business-ready dimensions and facts (Gold), it ensures your data transformations are performant, maintainable, and aligned with industry-standard dbt best practices.

주요 기능

• Materialization strategy guidance including ephemeral, table, and incremental types
• 23 GitHub stars
• Consistent CTE patterns for modular and readable SQL structure
• Standardized naming conventions and metadata column implementation
• Medallion architecture templates for staging, intermediate, and mart layers
• Advanced modeling patterns for handling SCDs, ghost keys, and window functions

사용 사례

• Refactoring existing SQL scripts into organized, production-grade dbt models
• Designing a structured data warehouse from source tables to analytics-ready marts
• Optimizing large-scale data transformations with incremental loading and clustering strategies