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.

1.75x

Quality

83%

Does it follow best practices?

Impact

93%

1.75x

Average score across 3 eval scenarios

Securityby

Passed

No findings from the security scan

Quality

Content

73%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-structured, actionable skill with a strong validation-first workflow and feedback loop. The main weakness is redundancy — synonyms/comments and validation guidance are repeated across sections and could be consolidated to tighten the token budget.

Suggestions

Consolidate the synonyms/comments guidance so it appears once (either in the workflow step or the dedicated section) rather than restated nearly verbatim in both places.

Merge the 'Validation Pattern' section into the workflow step 7/8 description to eliminate the third repetition of the validation requirement.

Inline a minimal CREATE SEMANTIC VIEW DDL skeleton (dimensions/facts/metrics) so Claude has an executable starting point without needing to load the external doc URL.

Dimension	Reasoning	Score
Conciseness	The body is mostly lean and assumes Claude's competence, but the synonyms/comments guidance is restated nearly verbatim in both step 4 and the 'Synonyms And Comments' section, and the validation pattern is repeated across the workflow, a dedicated section, and the example template.	3 / 5
Actionability	Provides concrete executable commands ('snow --help', 'snow connection add', 'snow sql -q "..." --connection'), a SEMANTIC_VIEW() query example, and SELECT DISTINCT/LIMIT 1000 discovery guidance, though the actual DDL syntax is delegated to an external doc URL rather than shown inline.	4 / 5
Workflow Clarity	An 11-step numbered workflow with an explicit validation checkpoint (step 7), a feedback loop ('iterate on the DDL and re-run the validation step until it succeeds'), and cleanup of the temporary view — clear sequencing with error recovery for a database DDL operation.	5 / 5
Progressive Disclosure	No bundle files exist; content is a single well-organized file with clear section headers and external doc links that are one level deep, though at ~83 lines it slightly exceeds the simple-skill threshold where structure alone would warrant a 5.	4 / 5
	Total	16 / 20 Passed

Description

92%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong, specific description that clearly conveys both capability and trigger conditions for a well-scoped niche. Minor improvement possible by adding a few more natural user-facing synonyms alongside the technical terms.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions — 'Create, alter, and validate Snowflake semantic views', 'validate semantic-view DDL against Snowflake via CLI', and 'guide Snowflake CLI installation and connection setup' — giving comprehensive coverage of the skill's capabilities.	5 / 5
Completeness	Explicitly states both what the skill does and when to use it via a concrete 'Use when asked to build or troubleshoot… to validate… or to guide…' clause with multiple trigger phrases.	5 / 5
Trigger Term Quality	Includes natural phrases users would say ('build or troubleshoot semantic views/semantic layer definitions', 'CREATE/ALTER SEMANTIC VIEW', 'DDL', 'Snowflake CLI') with some synonym coverage, but 'snow' is jargon and a few natural variations are missing.	4 / 5
Distinctiveness Conflict Risk	Targets a clear niche (Snowflake semantic views via Snowflake CLI) with distinct triggers, making overlap with other skills minimal.	5 / 5
	Total	19 / 20 Passed

Validation

100%

Warnings & errors only

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository: github/awesome-copilot
Path: skills/snowflake-semanticview/SKILL.md
Commit: 406c31f

Reviewed: about 19 hours ago

Table of Contents

Discovery Implementation Validation

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.