CtrlK
BlogDocsLog inGet started
Tessl Logo

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.

92

1.75x
Quality

90%

Does it follow best practices?

Impact

93%

1.75x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

81%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 strong, safety-conscious skill body: the workflow is unambiguous, validation is mandatory with an explicit retry loop and temporary-name protection, and guidance is concrete. The main weaknesses are the duplicated synonyms/comments guidance and the placeholder DDL that never shows a complete worked example.

Suggestions

Consolidate the synonyms/comments guidance into a single section — workflow step 4 and the 'Synonyms And Comments' section repeat the same instructions (including the identical 'ask whether you can create them...' bullet), so keep one and reference it from the other.

Replace the placeholder 'CREATE OR ALTER SEMANTIC VIEW ...' in the validation template with a minimal complete example DDL so the validate-fix-retry loop is copy-paste executable.

Merge the one-time setup details (installation URL, connection configuration) into the existing 'One-Time Setup' section's neighbors or trim the 'Notes' section, which partially restates guidance already given inline.

DimensionReasoningScore

Conciseness

The body is lean and assumes competence — it never explains what semantic views or SQL are, and URLs carry the syntax details instead of inlining them. However, the synonyms/comments guidance is duplicated nearly verbatim (workflow step 4 and the 'Synonyms And Comments' section, including the identical 'ask whether you can create them...' bullet), which is noticeable redundancy that could be trimmed. This sits between 'Mostly efficient but includes some unnecessary explanation' (3) and 'Efficient; minor instances of over-explanation that could be trimmed' (4), clearly closer to 4 since the only waste is repetition, not padding.

4 / 5

Actionability

Mostly executable guidance: concrete commands (`snow --help`, `snow connection add`, `snow sql -q "..." --connection <connection_name>`), a copy-paste sample SEMANTIC_VIEW query, and a concrete discovery technique (SELECT DISTINCT with LIMIT 1000). The gap is that the core DDL is only a placeholder — "snow sql -q \"<CREATE OR ALTER SEMANTIC VIEW ...>\"" — and the synonyms block is a syntax sketch rather than a filled-in example, so nothing DDL-wise is copy-paste ready. This matches 'Mostly executable guidance; concrete code or commands with minor gaps'; a 5 would require complete examples covering the common case, which the placeholder prevents.

4 / 5

Workflow Clarity

The 11-step workflow is clearly sequenced with an explicit validation checkpoint (step 7: 'Always validate by sending the DDL to Snowflake via Snowflake CLI before finalizing'), a feedback loop (step 8: 'If validation fails, iterate on the DDL and re-run the validation step until it succeeds'), a temp-name pattern to avoid clobbering the real view, a post-creation sample query, and a cleanup step. This matches the anchor 'Clear sequence with explicit validation steps; feedback loops for error recovery' — notably strong given the database-operation context where validation is essential; a 4 would require minor checkpoint gaps, and none are evident.

5 / 5

Progressive Disclosure

The ~80-line body is organized into clear, well-labeled sections (One-Time Setup, Workflow, Synonyms And Comments, Validation Pattern, Notes) with no nested or buried references, and external syntax details are delegated to docs URLs. It does not fully hit the anchor 'Clear overview with well-signaled one-level-deep references; content appropriately split' because the duplicated synonyms/comments material should be consolidated into one section, and the workflow section mixes setup-adjacent detail with the core loop — minor organization gaps characteristic of a 4.

4 / 5

Total

17

/

20

Passed

Description

100%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.

The description is exemplary: it names the tool, the artifact, and the operations in third person, and provides an explicit 'Use when...' clause with concrete, natural trigger phrases including a synonym ('semantic layer definitions'). No vague language, buzzwords, or over-claims are present.

DimensionReasoningScore

Specificity

The description lists multiple specific concrete actions — "Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow)", "validate semantic-view DDL against Snowflake via CLI", and "guide Snowflake CLI installation and connection setup" — giving comprehensive coverage of the skill's operations. It matches the anchor 'Lists multiple specific concrete actions; comprehensive coverage'; a 4 would require minor coverage gaps, but create/alter/validate/setup are all covered.

5 / 5

Completeness

It explicitly answers both questions: the 'what' is stated upfront ("Create, alter, and validate Snowflake semantic views using Snowflake CLI") and the 'when' is given as an explicit "Use when asked to..." clause with three concrete trigger scenarios. This is a direct match for the anchor 'Clearly and explicitly answers both what AND when with concrete trigger phrases'; a 4 would require the 'when' to be less explicit, which it is not.

5 / 5

Trigger Term Quality

Natural trigger phrases users would say are well covered: "build or troubleshoot semantic views", "semantic layer definitions" (a common synonym for semantic views), "CREATE/ALTER SEMANTIC VIEW", and "Snowflake CLI". The synonym pairing of 'semantic views' with 'semantic layer definitions' mirrors the anchor's 'comprehensive coverage of natural terms including synonyms'; there is no meaningful term a Snowflake user would add.

5 / 5

Distinctiveness Conflict Risk

The niche is highly specific — Snowflake semantic views via the Snowflake CLI tool — with triggers keyed to Snowflake-specific DDL ("CREATE/ALTER SEMANTIC VIEW"). Virtually no other skill would claim these triggers, matching the anchor 'Clear niche with distinct triggers; minimal conflict risk'; even closely related SQL or Snowflake skills would not collide with these semantic-view-specific terms.

5 / 5

Total

20

/

20

Passed

Validation

100%

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
Reviewed

Table of Contents

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.