What problem does it solve? When optimizing or debugging Snowflake semantic models, you need proof that changes produce correct results. This Skill validates semantic model syntax and compares ground truth SQL against generated SQL, enforcing exact data matches so incorrect optimizations never pass silently. ## Core Features & Use Cases - Semantic Model Syntax Validation: Runs reflect_semantic_model to check YAML syntax, schema compliance, and configuration validity, with a retry-then-remove fallback for failing entities. - SQL Execution & Exact Comparison: Executes both ground truth and generated SQL, then compares row counts and data values requiring 100% exact matches. - Structured Failure Reporting: Reports PASS/FAIL status for the semantic model, SQL execution, and data comparison, then routes failures back to root cause analysis. - Use Case: After generating an optimization for a semantic view, run this validation to confirm the optimized SQL returns byte-identical results to the original query before accepting the change. ## Quick Start Validate my semantic model changes by running the ground truth and generated SQL and confirming the results match exactly.
