snowflake-prod-checklist

# Snowflake Production Checklist ## Overview Complete checklist for deploying Snowflake data pipelines and integrations to production. ## Prerequisites - Staging environment validated - Production Snowflake account configured - Resource monitors in place - Monitoring infrastructure ready ## Pre-Deployment Checklist ### Authentication & Secrets - [ ] Service accounts use key pair auth (not password) - [ ] Private keys stored in secret manager (not files/env vars) - [ ] Key rotation procedure documented and tested - [ ] Network policy applied to production account - [ ] Connection parameters use production account identifier ### Warehouse Configuration - [ ] Production warehouses created with appropriate sizing - [ ] Auto-suspend configured (60-300s based on workload) - [ ] Auto-resume enabled - [ ] Resource monitors with credit quotas and alerts - [ ] Separate warehouses for ETL, analytics, and dashboard workloads ```sql -- Production warehouse setup CREATE WAREHOUSE IF NOT EXISTS PROD_ETL_WH WAREHOUSE_SIZE = 'LARGE' AUTO_SUSPEND = 120 AUTO_RESUME = TRUE; CREATE WAREHOUSE IF NOT EXISTS PROD_ANALYTICS_WH WAREHOUSE_SIZE = 'MEDIUM' MIN_CLUSTER_COUNT = 1 MAX_CLUSTER_COUNT = 3 SCALING_POLICY = 'STANDARD' AUTO_SUSPEND = 300 AUTO_RESUME = TRUE; -- Resource monitor with alerts CREATE OR REPLACE RESOURCE MONITOR prod_monitor WITH CREDIT_QUOTA = 1000 FREQUENCY = MONTHLY START_TIMESTAMP = IMMEDIATELY TRIGGERS ON 75 PERCENT DO NOTIFY ON 90 PERCE...