snowflake-deploy-integration

# 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...