MaxMyCloud logo

Warehouse Monitor

Purpose

The Warehouse Monitor continuously monitors all warehouses in your Snowflake account and automatically suspends any warehouse that remains active beyond a specified inactivity threshold. This helps avoid unnecessary compute costs by acting as a safeguard against accidentally leaving warehouses running idle.

Note: This tool is not intended to replace Snowflake’s native auto-suspend feature. We strongly recommend setting Snowflake’s auto-suspend to 60 seconds instead of relying on the Snowflake default to maximize cost efficiency. The Warehouse Monitor acts as a safeguard to ensure warehouses are not inadvertently left running idle.

Configuration Guide

Navigate to Operations → WH Schedule. A list of available Snowflake warehouses will be displayed.

Warehouse Scheduler
  1. Define the Inactivity Threshold:
    Set the inactivity threshold (in seconds) between 0 and 60. While any value is permitted, we recommend staying under 60 seconds. You may also exclude specific warehouses from this threshold.
  2. Select Warehouse Sizes to Monitor:
    Choose which warehouse sizes to monitor. You can either select all sizes or target specific ones depending on your cost management strategy.
  3. Include or Exclude Specific Warehouses:
    Use the Include or Exclude radio options in the configuration table to refine which warehouses are affected by the monitor.
  4. Once configuration is complete, click the “Save & Monitor” button to activate monitoring.

Enabling & Disabling the Monitor

  • The Warehouse Monitor is disabled by default. It will not begin monitoring until you explicitly activate it by clicking “Save & Monitor.”
  • To stop monitoring at any time, click the “Disable Monitor” button.