snowflake-cost-tuning
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". '
Profile →npx skills add jeremylongshore/claude-code-plugins-plus-skills --skill snowflake-cost-tuning --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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
- Overview
- Snowflake Pricing Model
- Instructions
- Step 1: Analyze Current Credit Consumption
- Step 2: Set Up Resource Monitors
- Step 3: Optimize Auto-Suspend
- Step 4: Right-Size Warehouses
- Step 5: Reduce Storage Costs
- Step 6: Serverless Feature Cost Control
- Cost Reduction Checklist
- Error Handling
- Resources
- Next Steps
What does the snowflake-cost-tuning skill do?
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". '
How do I install it?
Run `npx skills add jeremylongshore/claude-code-plugins-plus-skills --skill snowflake-cost-tuning --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From jeremylongshore/claude-code-plugins-plus-skills, a repository with 2,630 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.