snowflake-cost-tuning

Featured

Optimize Snowflake costs with resource monitors, warehouse auto-suspend, right-sizing, and credit consumption analysis. Use when analyzing Snowflake billing, reducing credit consumption, or implementing cost controls and budget alerts. Trigger with phrases like "snowflake cost", "snowflake billing", "reduce snowflake cost", "snowflake credits", "snowflake expensive", "snowflake budget".

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

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

Data & Documents Listed

optimizing-snowflake-workloads

Reduce Snowflake cost and latency — right-size and auto-suspend warehouses, use multi-cluster for concurrency, apply clustering keys, read the Query Profile, exploit result/warehouse caching, and control credit spend. Use when Snowflake queries are slow or expensive, warehouses spill or queue, credits are high, or you need to size a warehouse.

27 Updated 2 months ago
Unknown-333
Data & Documents Listed

cost-optimization-data

Query cost analysis, partition pruning, slot reservation strategies, storage tiering, and cloud data warehouse cost reduction. Use this skill whenever the cloud data bill is unexpectedly high, a specific query is scanning too much data, the team wants to understand what's driving BigQuery/Snowflake/Redshift costs, or when choosing between on-demand vs. reserved capacity. Also trigger when the user mentions bytes scanned, slot utilization, query cost, storage costs, Redshift concurrency, Snowflake credits, or when trying to set up cost alerts and budgets. If someone says "our BigQuery bill jumped" or "this query is expensive", this skill should be active immediately.

1 Updated 4 months ago
Methasit-Pun
AI & Automation Featured

snowflake-load-scale

Implement Snowflake load testing, warehouse scaling, and capacity planning. Use when testing query performance at scale, configuring multi-cluster warehouses, or planning capacity for production Snowflake workloads. Trigger with phrases like "snowflake load test", "snowflake scale", "snowflake capacity", "snowflake benchmark", "snowflake multi-cluster".

2,926 Updated yesterday
jeremylongshore