snowflake-semanticview
Installation
Summary
Build and validate Snowflake semantic views using Snowflake CLI with guided DDL creation and testing.
- Handles the complete semantic view lifecycle: drafting DDL, populating synonyms and comments from Snowflake table metadata, validating against Snowflake via CLI, and executing final CREATE or ALTER statements
- Requires one-time Snowflake CLI installation and connection setup; confirms prerequisites before proceeding with validation
- Validates all DDL against Snowflake using temporary view names before applying final definitions, then runs sample queries to confirm functionality
- Guides discovery of fact-dimension relationships and column metadata through SELECT statements, and manages synonyms and comments as required semantic view components
SKILL.md
Snowflake Semantic Views
One-Time Setup
- Verify Snowflake CLI installation by opening a new terminal and running
snow --help. - If Snowflake CLI is missing or the user cannot install it, direct them to https://docs.snowflake.com/en/developer-guide/snowflake-cli/installation/installation.
- Configure a Snowflake connection with
snow connection addper https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-connections#add-a-connection. - Use the configured connection for all validation and execution steps.