snowflake-cost-tuning

# Snowflake Cost Tuning ## Overview Optimize Snowflake costs through resource monitors, warehouse right-sizing, auto-suspend tuning, and credit consumption analysis. ## Snowflake Pricing Model | Cost Component | What It Measures | Typical % of Bill | |---------------|-----------------|-------------------| | Compute (credits) | Warehouse running time | 60-80% | | Storage | Data at rest (compressed) | 10-20% | | Cloud services | Metadata ops, auth, compilation | 5-10% | | Data transfer | Egress between regions/clouds | 0-5% | | Serverless | Snowpipe, auto-clustering, MV refresh | Variable | **Credit rates by warehouse size:** | Size | Credits/Hour | Nodes | |------|-------------|-------| | X-Small | 1 | 1 | | Small | 2 | 2 | | Medium | 4 | 4 | | Large | 8 | 8 | | X-Large | 16 | 16 | | 2X-Large | 32 | 32 | ## Instructions ### Step 1: Analyze Current Credit Consumption ```sql -- Credits by warehouse (last 30 days) SELECT warehouse_name, SUM(credits_used) AS total_credits, SUM(credits_used_compute) AS compute_credits, SUM(credits_used_cloud_services) AS cloud_credits, ROUND(SUM(credits_used) * 3.0, 2) AS est_cost_usd -- ~$3/credit standard FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY WHERE start_time >= DATEADD(days, -30, CURRENT_TIMESTAMP()) GROUP BY warehouse_name ORDER BY total_credits DESC; -- Daily credit trend SELECT DATE_TRUNC('day', start_time) AS day, SUM(credits_used) AS credits FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOU...