07-design-validation

What problem does it solve?

This Skill prevents costly implementation bugs by automatically cross-validating all Gold layer design artifacts, ensuring consistency between YAML schemas, ERDs, and lineage documentation before development begins.

Core Features & Use Cases

• Cross-Artifact Validation: Compares YAML schemas against ERD diagrams to catch missing or extra columns and tables.
• Lineage Verification: Ensures every Gold layer column has a documented lineage path.
• PK/FK Integrity: Validates that all foreign key references correctly point to primary keys in other tables.
• Mandatory Field Check: Confirms that all YAML schemas adhere to required properties and constraints (e.g., clustering, PK nullability).
• Use Case: Before handing off the design for a new customer dimension table to the engineering team, run this skill to confirm that the ERD accurately reflects the YAML schema, all columns have lineage, and foreign keys are correctly defined, preventing potential runtime errors.

Quick Start

Run the complete design validation suite for the gold layer using the provided project directory.