snowflake-prod-checklist

Featured

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

AI & Automation 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 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...

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