Snowflake Deploy Integration

Overview

Deploy Snowflake-powered applications to popular platforms with proper secrets management.

Prerequisites

• Snowflake API keys for production environment
• Platform CLI installed (vercel, fly, or gcloud)
• Application code ready for deployment
• Environment variables documented

Vercel Deployment

Environment Setup

# Add Snowflake secrets to Vercel
vercel secrets add snowflake_api_key sk_live_***
vercel secrets add snowflake_webhook_secret whsec_***

# Link to project
vercel link

# Deploy preview
vercel

# Deploy production
vercel --prod

vercel.json Configuration

{
  "env": {
    "SNOWFLAKE_API_KEY": "@snowflake_api_key"
  },
  "functions": {
    "api/**/*.ts": {
      "maxDuration": 30
    }
  }
}

Fly.io Deployment

fly.toml

app = "my-snowflake-app"
primary_region = "iad"

[env]
  NODE_ENV = "production"

[http_service]
  internal_port = 3000
  force_https = true
  auto_stop_machines = true
  auto_start_machines = true

Secrets

# Set Snowflake secrets
fly secrets set SNOWFLAKE_API_KEY=sk_live_***
fly secrets set SNOWFLAKE_WEBHOOK_SECRET=whsec_***

# Deploy
fly deploy

Google Cloud Run

Dockerfile

FROM node:20-slim
WORKDIR /app
COPY package*.json ./
RUN npm ci --only=production
COPY . .
CMD ["npm", "start"]

Deploy Script

#!/bin/bash
# deploy-cloud-run.sh

PROJECT_ID="${GOOGLE_CLOUD_PROJECT}"
SERVICE_NAME="snowflake-service"
REGION="us-central1"

# Build and push image
gcloud builds submit --tag gcr.io/$PROJECT_ID/$SERVICE_NAME

# Deploy to Cloud Run
gcloud run deploy $SERVICE_NAME \
  --image gcr.io/$PROJECT_ID/$SERVICE_NAME \
  --region $REGION \
  --platform managed \
  --allow-unauthenticated \
  --set-secrets=SNOWFLAKE_API_KEY=snowflake-api-key:latest

Environment Configuration Pattern

// config/snowflake.ts
interface SnowflakeConfig {
  apiKey: string;
  environment: 'development' | 'staging' | 'production';
  webhookSecret?: string;
}

export function getSnowflakeConfig(): SnowflakeConfig {
  const env = process.env.NODE_ENV || 'development';

  return {
    apiKey: process.env.SNOWFLAKE_API_KEY!,
    environment: env as SnowflakeConfig['environment'],
    webhookSecret: process.env.SNOWFLAKE_WEBHOOK_SECRET,
  };
}

Health Check Endpoint

// api/health.ts
export async function GET() {
  const snowflakeStatus = await checkSnowflakeConnection();

  return Response.json({
    status: snowflakeStatus ? 'healthy' : 'degraded',
    services: {
      snowflake: snowflakeStatus,
    },
    timestamp: new Date().toISOString(),
  });
}

Instructions

Step 1: Choose Deployment Platform

Select the platform that best fits your infrastructure needs and follow the platform-specific guide below.

Step 2: Configure Secrets

Store Snowflake API keys securely using the platform's secrets management.

Step 3: Deploy Application

Use the platform CLI to deploy your application with Snowflake integration.

Step 4: Verify Health

Test the health check endpoint to confirm Snowflake connectivity.

Output

• Application deployed to production
• Snowflake secrets securely configured
• Health check endpoint functional
• Environment-specific configuration in place

Error Handling

Examples

Quick Deploy Script

#!/bin/bash
# Platform-agnostic deploy helper
case "$1" in
  vercel)
    vercel secrets add snowflake_api_key "$SNOWFLAKE_API_KEY"
    vercel --prod
    ;;
  fly)
    fly secrets set SNOWFLAKE_API_KEY="$SNOWFLAKE_API_KEY"
    fly deploy
    ;;
esac

Resources

• Vercel Documentation
• Fly.io Documentation
• Cloud Run Documentation
• Snowflake Deploy Guide

Next Steps

For webhook handling, see snowflake-webhooks-events.