snowflake-sdk-patterns
Apply production-ready Snowflake SDK patterns for snowflake-sdk and snowflake-connector-python. Use when implementing connection pooling, async execute wrappers, streaming results, or establishing team coding standards for Snowflake. Trigger with phrases like "snowflake SDK patterns", "snowflake best practices", "snowflake code patterns", "idiomatic snowflake", "snowflake connection pool". '
Profile →npx skills add jeremylongshore/claude-code-plugins-plus-skills --skill snowflake-sdk-patterns --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Snowflake SDK Patterns ## Overview Production-ready patterns for `snowflake-sdk` (Node.js) and `snowflake-connector-python` using real driver APIs. ## Prerequisites - Completed `snowflake-install-auth` setup - Understanding of callback-to-promise conversion patterns - Familiarity with Snowflake's callback-based Node.js API ## Instructions ### Step 1: Connection Pool (Node.js) ```typescript // src/snowflake/pool.ts import snowflake from 'snowflake-sdk'; interface PoolConfig { max: number; idleTimeoutMs: number; } class SnowflakePool { private pool: snowflake.Connection[] = []; private available: snowflake.Connection[] = []; private waiting: ((conn: snowflake.Connection) => void)[] = []; private config: PoolConfig; constructor( private connConfig: snowflake.ConnectionOptions, config: Partial<PoolConfig> = {} ) { this.config = { max: 10, idleTimeoutMs: 60000, ...config }; } async acquire(): Promise<snowflake.Connection> { // Return available connection if (this.available.length > 0) { return this.available.pop()!; } // Create new if under limit if (this.pool.length < this.config.max) { const conn = snowflake.createConnection(this.connConfig); await new Promise<void>((resolve, reject
- Overview
- Prerequisites
- Instructions
- Step 1: Connection Pool (Node.js)
- Step 2: Promise-Based Query Helper
- Step 3: Streaming for Large Result Sets
- Step 4: Python Context Manager Pattern
- Step 5: Error Handling Wrapper
- Error Handling
- Resources
- Next Steps
What does the snowflake-sdk-patterns skill do?
Apply production-ready Snowflake SDK patterns for snowflake-sdk and snowflake-connector-python. Use when implementing connection pooling, async execute wrappers, streaming results, or establishing team coding standards for Snowflake. Trigger with phrases like "snowflake SDK patterns", "snowflake best practices", "snowflake code patterns", "idiomatic snowflake", "snowflake connection pool". '
How do I install it?
Run `npx skills add jeremylongshore/claude-code-plugins-plus-skills --skill snowflake-sdk-patterns --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From jeremylongshore/claude-code-plugins-plus-skills, a repository with 2,630 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.