datamart-lld-design

What problem does it solve?

This Skill eliminates inconsistent, error-prone manual Low-Level Design (LLD) for Datamart layers in data warehouse projects, ensuring alignment with approved High-Level Design (HLD) and Atomic data models to avoid costly rework and schema mismatches.

Core Features & Use Cases

• 3-Phase Structured Workflow: Guides data modelers through Phase 1 (Attributes CSV generation), Phase 2 (KPI Detail Mapping), and Phase 3 (ClickHouse flat table SQL generation) with strict, mandatory gate checks between phases.
• Built-in Validation: Includes 5 mandatory self-review test cases for Phase 1, 4 for Phase 2, and cross-checks against HLD, Atomic entity YAML files, and BA requirements to catch mapping errors before delivery.
• Use Case: For UBCKNN lakehouse project data modelers, this Skill automates LLD generation for Datamart modules while enforcing governance rules for source system code filtering, ETL logic formatting, and key constraint compliance.

Quick Start

Provide the approved HLD and Entities files for your target Datamart module to generate a compliant Phase 1 Attributes CSV with validated ETL source mappings.