snowflake-deploy-integration

Featured

Deploy Snowflake-powered applications with proper connection management and secrets. Use when deploying apps that query Snowflake, configuring connection pools for serverless/container platforms, or managing Snowflake credentials in production. Trigger with phrases like "deploy snowflake", "snowflake serverless", "snowflake production deploy", "snowflake Cloud Run", "snowflake Lambda".

DevOps & Infrastructure 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Snowflake Deploy Integration ## Overview Deploy applications that connect to Snowflake on serverless platforms, containers, and VMs with proper connection lifecycle management. ## Prerequisites - Snowflake service account with key pair auth - Platform CLI installed (gcloud, aws, docker) - Application tested against staging Snowflake ## Instructions ### Step 1: Connection Management for Serverless ```typescript // src/snowflake/serverless-connection.ts import snowflake from 'snowflake-sdk'; let cachedConnection: snowflake.Connection | null = null; /** * Reuse connection across Lambda/Cloud Function invocations. * Serverless containers may be reused — avoid reconnecting every call. */ export async function getConnection(): Promise<snowflake.Connection> { if (cachedConnection?.isUp()) { return cachedConnection; } const conn = snowflake.createConnection({ account: process.env.SNOWFLAKE_ACCOUNT!, username: process.env.SNOWFLAKE_USER!, authenticator: 'SNOWFLAKE_JWT', privateKey: process.env.SNOWFLAKE_PRIVATE_KEY!, warehouse: process.env.SNOWFLAKE_WAREHOUSE!, database: process.env.SNOWFLAKE_DATABASE!, schema: process.env.SNOWFLAKE_SCHEMA || 'PUBLIC', clientSessionKeepAlive: true, // Keep session alive between invocations }); await new Promise<void>((resolve, reject) => { conn.connect((err) => (err ? reject(err) : resolve())); }); cachedConnection = conn; return conn; } ``` ### Step 2: Google Cloud Run Deploym...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category