Road to Snowflake SnowPro Core Certification: Resource Monitors

Eleventh Chapter: Resource Monitors

Gonzalo Fernandez Plaza

--

Chapter 11 of the SnowPro Core Course. Resource Monitors.
Chapter 11 of the SnowPro Core Course. Resource Monitors.

In all the cloud services, there must be something to control the price we spend. In Snowflake, this is controlled by Resource Monitors. Let’s study them in depth to be prepared for the SnowPro Core certification!

  1. Intro to Resource Monitors
  2. Resource Monitors Assignment
  3. Resource Monitors Parameters
  4. Typical Exam Questions on Resource Monitors

Remember that all the chapters from the course can be found in the following link:

RESOURCE MONITORS

We use Resource monitors to help control costs and avoid unexpected credit usage caused by running data warehouses. You can impose limits on the number of credits that warehouses consume. You can see the credits you’ve consumed in the Account section of the Snowflake UI (you must have an AccountAdmin role).

Consumed Credits by a Snowflake Account
Consumed Credits by a Snowflake Account

Resource Monitors are ONLY created by AccountAdmins, although roles with the MONITOR & MODIFY privileges can view and modify the resource monitor.

Resource Monitors Assignment

Resource monitors can be assigned in the following scenarios:

  • You can set a single monitor at the account level to control credit usage for all warehouses in your account.
  • You can assign a monitor to one or more warehouses, controlling the credit usage for each warehouse.
  • You can assign a warehouse to only a single resource monitor below the account level — this is a typical exam question.

We can see these three cases in the following diagram:

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com