Removes the specified resource monitor from the system.
Syntax¶DROP RESOURCE MONITOR [ IF EXISTS ] <name>
Copy
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.
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 information, see Working with resource monitors.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
Drop resource monitor my_rm, but don’t raise an error if the resource monitor doesn’t exist:
DROP RESOURCE MONITOR IF EXISTS my_rm;
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4