Resource Monitors & Budgets

Snowflake · Cost Management & Monitoring

Theory

A resource monitor tracks credits used by warehouses over an interval (daily, weekly, monthly, yearly or never) against a credit quota, and fires triggers at percentages you choose. Each trigger can NOTIFY, SUSPEND (stop the warehouse after running queries finish) or SUSPEND_IMMEDIATE (stop and cancel running queries). A monitor can be set for the whole account or assigned to specific warehouses, and each warehouse can have only one monitor.

Resource monitors only cover user-managed warehouses, not serverless features. Budgets complement them: a budget tracks spend for the account or a group of objects, including serverless usage, and sends notifications when projected spend exceeds the limit.

Why we use it

One runaway query, a warehouse with no auto-suspend or a bad loop can burn credits fast. Monitors and budgets catch this automatically, before the end-of-month bill does.

When to use it

Create monitors with notify triggers early (50 to 75%) and suspend triggers near the quota on every important warehouse, plus an account-level monitor as a backstop. Use budgets to watch serverless and whole-account spend.

Setting Thresholds

You define one or more percentage thresholds (e.g. 75% notify, 100% suspend) against a credit quota, and assign the monitor to one or more warehouses.

Suspend vs Suspend Immediately

A plain suspend lets already-running queries finish before stopping the warehouse; suspend immediately cancels queries in flight too — the harder stop for a hard budget ceiling.

Budgets for Account-Wide Spend

Where resource monitors watch warehouses, Budgets track and alert on spend across the whole account or a custom group of objects, including serverless features and AI services. Both live in Snowsight under Admin → Cost management.

How it works

  1. Warehouses consume credits
  2. Monitor compares usage with the quota
  3. Has a trigger percentage been reached? Yes: Run its action: notify, suspend or suspend immediately. No: Keep monitoring.
  4. Quota resets at the start of the next interval
  5. Review and adjust quotas regularly

Example

CREATE OR REPLACE RESOURCE MONITOR account_budget
  WITH CREDIT_QUOTA = 2000 FREQUENCY = MONTHLY START_TIMESTAMP = IMMEDIATELY
  TRIGGERS
    ON 50 PERCENT DO NOTIFY
    ON 75 PERCENT DO NOTIFY
    ON 90 PERCENT DO SUSPEND
    ON 100 PERCENT DO SUSPEND_IMMEDIATE;

ALTER ACCOUNT SET RESOURCE_MONITOR = account_budget;
SHOW RESOURCE MONITORS;

Key points

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic