Categories:
Warehouse & Resource Monitor DDL

DROP RESOURCE MONITOR

Removes the specified resource monitor from the system.

See also:
CREATE RESOURCE MONITOR , SHOW RESOURCE MONITORS

Syntax

DROP RESOURCE MONITOR <name>

Parameters

name
Specifies the identifier for the resource monitor to drop. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes

  • Dropped resource monitors cannot be recovered; they must be recreated.

  • Dropping a resource monitor immediately enables resuming any assigned warehouses that have been suspended due to the monitor reaching its monthly threshold.

    For more details, see Working with Resource Monitors.