Snowflake Semanticview

What it does

When your agent uses it

• Troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW
• Validate semantic-view DDL against Snowflake via CLI
• Guide Snowflake CLI installation and connection setup

Example prompts

• “/snowflake-semanticview”

Workflow steps

10 steps, taken from the first numbered list in SKILL.md.

1. 1Confirm the target database, schema, role, warehouse, and final semantic view name.
2. 2Confirm the model follows a star schema (facts with conformed dimensions).
3. 3Draft the semantic view DDL using the official syntax
4. 4Populate synonyms and comments for each dimension, fact, and metric
5. 5Use SELECT statements with DISTINCT and LIMIT (maximum 1000 rows) to discover relationships between fact and dimension tables, identify…
6. 6Create a temporary validation name (for example, append __tmp_validate) while keeping the same database and schema.
7. 7Always validate by sending the DDL to Snowflake via Snowflake CLI before finalizing
8. 8If validation fails, iterate on the DDL and re-run the validation step until it succeeds.
9. 9Apply the final DDL (create or alter) using the real semantic view name.
10. 10Run a sample query against the final semantic view to confirm it works as expected. It has a different SQL syntax as can be seen here…

What it can do on your machine

Read from SKILL.md and the folder at commit 727ff2e. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • snow

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Links to these hosts (documentation or services it may open):

  • docs.snowflake.com

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Snowflake Semanticview loads about 1.1k tokens when it runs. Until then it costs about 84 tokens; SKILL.md has 476 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~84

When it runs · the whole SKILL.md, loaded when a task matches

~1.1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from github/awesome-copilot at commit 727ff2e, republished under its MIT licence (© github). 476 words, ~1,103 tokens.

name

snowflake-semanticview

description

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.

SELECT * FROM SEMANTIC_VIEW(
    my_semview_name
    DIMENSIONS customer.customer_market_segment
    METRICS orders.order_average_value
)
ORDER BY customer_market_segment;

WITH SYNONYMS [ = ] ( 'synonym' [ , ... ] )
COMMENT = 'comment_about_dim_fact_or_metric'

# Replace placeholders with real values.
snow sql -q "<CREATE OR ALTER SEMANTIC VIEW ...>" --connection <connection_name>

snow sql --help

© github, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/snowflake-semanticview of github/awesome-copilot.

Open the folder on GitHubat commit 727ff2e

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in github/awesome-copilot, which our catalogue first saw on October 7, 2026.

• boshi-xixixi/TraeSkill.trae/Skills/.agents/skills/snowflake-semanticview