CtrlK
BlogDocsLog inGet started
Tessl Logo

snowpipe-streaming-quickstart

Automated quick-start for Snowpipe Streaming high-performance architecture (HPA). Detects your OS (macOS/Linux/Windows), verifies Python, sets up a virtual environment, creates a landing table, configures RSA key-pair auth, streams fake user data via the default auto-created pipe, and deploys a real-time Streamlit in Snowflake dashboard so you can watch rows arrive live. Triggers: snowpipe streaming quickstart, snowpipe streaming demo, demo snowpipe streaming, try snowpipe streaming, snowpipe streaming hpa quickstart.

79

2.77x
Quality

70%

Does it follow best practices?

Impact

97%

2.77x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No known issues

Fix and improve this skill with Tessl

tessl review fix ./skills/snowpipe-streaming-quickstart/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

55%

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

This skill excels at actionability and workflow clarity — every step has precise, executable commands with thorough error handling and clear sequencing. However, it is severely bloated: content is duplicated extensively (table DDL 3x, profile.json 2x, pipe naming 4x), large code blocks that should be in bundle files are inline, and explanatory text often states the obvious. The lack of any bundle files for a skill this complex results in a monolithic document that wastes significant token budget.

Suggestions

Move the full streaming_demo.py and streamlit_app.py scripts into separate bundle files (e.g., templates/streaming_demo.py and templates/streamlit_app.py) and reference them from the SKILL.md with brief descriptions.

Eliminate the Templates section entirely — it duplicates content already present in Steps 3, 4, and 5 with no added value.

Remove redundant explanations of the default pipe naming convention — state it once in 'Critical concepts' and reference that section elsewhere instead of re-explaining it in Steps 3, 4, 6, and Templates.

Cut explanatory paragraphs that describe obvious architecture (e.g., 'Local (your computer): Python script... Cloud (Snowflake): Receiving data...') — Claude and users can infer this from the commands themselves.

DimensionReasoningScore

Conciseness

The skill is extremely verbose at ~600+ lines. There is massive duplication: the table DDL appears three times (Step 3, Templates section), profile.json appears twice, the Streamlit deployment SQL appears twice, and the default pipe naming convention is explained at least four times. The demo script is included inline in full (~100 lines of Python) when it could be in a separate bundle file. Many explanatory paragraphs (e.g., 'What's happening: Local (your computer)... Cloud (Snowflake)...') explain obvious concepts. The architecture notes, security notes, and repeated error handling blocks add significant bloat.

1 / 3

Actionability

The skill provides fully executable, copy-paste-ready code for every step: exact Bash commands, complete SQL statements, full Python scripts, and specific error handling tables with causes and fixes. Every tool call is specified with the exact tool type (Bash, SQL, FileWrite) and complete command content.

3 / 3

Workflow Clarity

The workflow is exceptionally well-sequenced with 9 clearly numbered steps (0-8), explicit validation checkpoints (e.g., checking RSA_PUBLIC_KEY in DESC USER output, verifying SDK imports, confirming row counts in Step 7), error handling with recovery paths at every step, and a feedback loop for zero-row results. The parallelization strategy is explicitly specified for each step, and there's a clear confirmation gate before cleanup.

3 / 3

Progressive Disclosure

The entire skill is a monolithic wall of text with no bundle files to offload content. The full Python demo script (~100 lines), full Streamlit app (~80 lines), and a Templates section that duplicates earlier content are all inline. The demo script content, Streamlit app code, and detailed error handling tables should be in separate referenced files. There are no external file references despite the content clearly warranting them.

1 / 3

Total

8

/

12

Passed

Description

85%

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

This is a strong description that excels in specificity and completeness, clearly articulating a detailed multi-step workflow and providing explicit trigger phrases. Its main weakness is that the trigger terms are somewhat rigid and formulaic, missing natural language variations a user might employ when seeking this functionality. The description is well-suited for disambiguation in a large skill library due to its highly specific Snowflake/Snowpipe domain.

Suggestions

Expand trigger terms to include more natural variations like 'set up snowpipe streaming', 'get started with snowpipe', 'snowpipe streaming tutorial', 'streaming ingestion demo', or 'real-time data ingestion snowflake'.

DimensionReasoningScore

Specificity

The description lists multiple specific concrete actions: detects OS, verifies Python, sets up virtual environment, creates landing table, configures RSA key-pair auth, streams fake user data, and deploys a Streamlit dashboard. These are highly specific and actionable.

3 / 3

Completeness

The description clearly answers both 'what does this do' (automated quick-start covering OS detection, Python verification, venv setup, table creation, RSA auth, data streaming, and dashboard deployment) and 'when to use it' via the explicit Triggers section listing specific activation phrases.

3 / 3

Trigger Term Quality

The description includes explicit trigger phrases like 'snowpipe streaming quickstart' and 'snowpipe streaming demo', but these are fairly narrow and formulaic. It misses natural variations users might say like 'set up snowpipe', 'snowpipe streaming tutorial', 'get started with snowpipe', or 'streaming ingestion demo'.

2 / 3

Distinctiveness Conflict Risk

This skill occupies a very clear niche — Snowpipe Streaming HPA quickstart with specific Snowflake-related actions. The combination of Snowpipe Streaming, RSA key-pair auth, Streamlit in Snowflake, and the specific trigger phrases make it highly unlikely to conflict with other skills.

3 / 3

Total

11

/

12

Passed

Validation

90%

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

Validation10 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

skill_md_line_count

SKILL.md is long (847 lines); consider splitting into references/ and linking

Warning

Total

10

/

11

Passed

Repository
snowflakedb/snowpipe-streaming-sdk-examples
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.