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.

2.77x

Quality

70%

Does it follow best practices?

Impact

97%

2.77x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Fix and improve this skill with Tessl

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

Evaluation results

100%

91%

Snowpipe Streaming SDK Configuration Files

profile.json and demo script generation

Criteria

Without context

With context

Correct user field

100%

Correct role field

100%

Account URL format

100%

Hyphen in pipe name

100%

No CREATE PIPE

100%

SS_LOG_LEVEL env var

100%

StreamingIngestClient usage

100%

offset_token in append_row

100%

wait_for_commit called

100%

Faker for fake data

100%

Batch size 5 / 0.5s sleep

100%

91%

50%

Snowflake Streaming Infrastructure Setup Script

RSA key generation and Snowflake DDL batching

Criteria

Without context

With context

Single Bash command for keys

40%

90%

2048-bit RSA

100%

pkcs8 -nocrypt

100%

chmod 600 on private key

100%

Dedicated demo user

100%

ALTER USER SET RSA_PUBLIC_KEY

100%

GRANT OWNERSHIP on table

100%

SELECT granted back

100%

No CREATE PIPE in SQL

100%

SQL log separator format

62%

100%

DESC USER included

Warehouse grant

100%

48%

Snowpipe Streaming Demo Teardown and Dashboard Deployment Guide

Streamlit dashboard and teardown SQL

Criteria

Without context

With context

st.connection snowflake

100%

Auto-refresh with st.rerun

100%

2-second refresh interval

100%

Four metric columns

100%

Cumulative revenue chart

100%

ttl=0 on queries

100%

Teardown: Streamlit dropped first

100%

Teardown: CASCADE on schema

100%

Teardown: demo user and role dropped

50%

100%

Teardown: database dropped last

100%

IF EXISTS on drops

100%

Wide layout

100%

Repository: snowflakedb/snowpipe-streaming-sdk-examples
Commit: 25dfdc4

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Snowpipe Streaming SDK Configuration Files Snowflake Streaming Infrastructure Setup Script Snowpipe Streaming Demo Teardown and Dashboard Deployment Guide

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.