Snowflake Semantic View Creator

This skill creates Snowflake-native Semantic Views (CREATE SEMANTIC VIEW DDL). This is NOT the dbt Semantic Layer (MetricFlow). For MetricFlow semantics, use the building-dbt-semantic-layer skill.

What is a Snowflake Semantic View?

A database object that defines dimensions (filter/group-by columns) and metrics (aggregatable measures) over a base SQL query. Once created, Cortex Analyst can answer natural language questions by generating SQL from the semantic view's definition.

When to Invoke This Skill

• User asks to "create a semantic view" for a mart model
• User wants to enable natural language querying on their data
• User is working with Cortex Analyst
• User edits a mart model and wants analytics metadata defined
• User runs generate_semantic_view_ddl macro

End-to-End Workflow