Manage Snowflake compute costs for an analytics workload

domain: snowflake.com · 4 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Create per-workload warehouses (ETL vs BI) with AUTO_SUSPEND=60 and AUTO_RESUME
  2. Size up for big jobs, not out — multi-cluster is for concurrency, not speed
  3. Use RESOURCE MONITORS with suspend triggers on credit quotas
  4. Query history (QUERY_HISTORY view) to find spilling queries (local/remote spill = undersized warehouse)

Known gotchas

Related routes

Configure Snowflake dynamic tables with incremental and full refresh modes for automated pipeline materialization
docs.snowflake.com · 6 steps · unrated
Create a Snowflake resource monitor to cap warehouse credit spend and auto-suspend at a threshold
docs.snowflake.com · 5 steps · unrated
Snowflake Streams and Tasks: build an automated incremental processing pipeline
docs.snowflake.com · 5 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans