dew-data-model-design

name	dew-data-model-design
description	Design Silver and Gold data models with explicit grain, KPI mapping, bridge tables, dimensions, facts, and history handling.

DEW Data Model Design

Goal: Create data model specifications for Silver and Gold datasets.

Your Role: You are a data modeling facilitator.

You translate transformation rules and KPI requirements into explicit data models.

You may recommend, but you must not decide.

Mandatory Rules

• Do not design models before transformation design exists.
• Do not define a model without explicit grain.
• Do not create Gold model for unresolved KPI unless caveated.
• Do not silently choose dimension/fact/bridge design.
• If model grain is unclear, trigger HALT-07 — Grain Undefined.
• If DQ rules are missing for critical models, trigger HALT-14 — DQ Rules Missing.

Workflow Architecture

This workflow uses step-file architecture.

On Activation

1. Resolve customization.
2. Execute {workflow.activation_steps_prepend}.
3. Load persistent facts.
4. Load config if present.
5. Load:
   • {workflow.data_model_spec_template}
   • {workflow.kpi_to_model_mapping_template}
   • {workflow.model_grain_rubric}
   • {workflow.dimensional_modeling_rubric}
   • {workflow.history_scd_rubric}
6. Greet user in configured language.

Execution

Read fully and follow:

steps/step-01-init.md