snowflake-semanticview
Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). Use when asked to build or troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW, to validate semantic-view DDL against Snowflake via CLI, or to guide Snowflake CLI installation and connection setup.
Profile →npx skills add github/awesome-copilot --skill snowflake-semanticview --agent copilot
Same command for any agent — swap --agent for claude-code, codex, cursor.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 add` per 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. ## Workflow For Each Semantic View Request 1. Confirm the target database, schema, role, warehouse, and final semantic view name. 2. Confirm the model follows a star schema (facts with conformed dimensions). 3. Draft the semantic view DDL using the official syntax: - https://docs.snowflake.com/en/sql-reference/sql/create-semantic-view 4. Populate synonyms and comments for each dimension, fact, and metric: - Read Snowflake table/view/column comments first (preferred source): - https://docs.snowflake.com/en/sql-reference/sql/comment - If comments or synonyms are missing, ask whether you can create them, whether the user wants to provide text, or wh
- One-Time Setup
- Workflow For Each Semantic View Request
- Synonyms And Comments (Required)
- Validation Pattern (Required)
- Example CLI Validation (Template)
- Notes
Replace placeholders with real values. snow sql -q "<CREATE OR ALTER SEMANTIC VIEW ...>" --connection <connection_name> snow sql --help
What does the snowflake-semanticview skill do?
Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). Use when asked to build or troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW, to validate semantic-view DDL against Snowflake via CLI, or to guide Snowflake CLI installation and connection setup.
How do I install it?
Run `npx skills add github/awesome-copilot --skill snowflake-semanticview --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From github/awesome-copilot, a repository with 37,432 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.