What problem does it solve? Teams that model metrics in Omni Analytics often need those same definitions hardened into Snowflake so tools like Cortex Analyst can query them directly. Manually translating Omni topics, views, joins, and measures into Snowflake Semantic View YAML is error-prone and slow, especially with field exclusions, templated filters, and join hierarchies. ## Core Features & Use Cases - Omni Model Exploration: Uses the Omni CLI to fetch topic files, relationships, and view definitions from the Shared Model via API. - Full Semantic Translation: Maps Omni dimensions, time dimensions, groups, bins, durations, booleans, and measures (including derived and filtered measures) into Snowflake Semantic View YAML, resolving templated filter-only fields to static SQL. - Environment-Aware Execution: Detects whether it runs in Cortex Code or an external IDE and executes SYSTEM$CREATE_SEMANTIC_VIEW_FROM_YAML plus GRANT statements via snow CLI, SnowSQL, or the Python connector. - Use Case: A data engineer wants to expose the ecomm order_items topic to Snowflake Cortex Analyst. The skill explores the Omni model, resolves the field list and relationships, generates the Semantic View YAML, creates the view in the target database/schema, and grants access to the chosen role. ## Quick Start Convert my Omni order_items topic into a Snowflake Semantic View named ORDER_ANALYTICS in ANALYTICS.PUBLIC and grant SELECT to the ANALYST role.
