Dimensional Model Validator
Installation
SKILL.md
Dimensional Model Validator
Overview
Validates dimensional models against Kimball methodology best practices. This skill ensures dimensional models conform to proven design patterns for analytical workloads.
Capabilities
- Star/snowflake schema validation
- Grain definition verification
- Surrogate key design validation
- SCD type appropriateness check
- Conformed dimension analysis
- Fact table type validation (transaction, periodic, accumulating)
- Degenerate dimension identification
- Role-playing dimension detection
- Bus matrix compliance checking