snowflake-prod-checklist

name	snowflake-prod-checklist
description	Execute Snowflake production readiness checklist with monitoring and rollback. Use when deploying Snowflake pipelines to production, preparing for go-live, or validating production Snowflake configuration. Trigger with phrases like "snowflake production", "snowflake go-live", "snowflake launch checklist", "snowflake prod ready".
allowed-tools	Read, Bash(kubectl:*), Bash(curl:*), Grep
version	1.5.0
license	MIT
author	Jeremy Longshore <[e-mail]>
tags	["saas","data-warehouse","analytics","snowflake"]
compatibility	Designed for Claude Code

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

-- 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  
  AUTO_SUSPEND  
  AUTO_RESUME  ;


  REPLACE RESOURCE MONITOR prod_monitor
   CREDIT_QUOTA  
  FREQUENCY  MONTHLY
  START_TIMESTAMP  IMMEDIATELY
  TRIGGERS
       DO NOTIFY
       DO NOTIFY
       DO SUSPEND
       DO SUSPEND_IMMEDIATE;

 WAREHOUSE PROD_ETL_WH  RESOURCE_MONITOR  prod_monitor;
 WAREHOUSE PROD_ANALYTICS_WH  RESOURCE_MONITOR  prod_monitor;