DELETE_QUERY_MONITOR

Stored procedure DELETE_QUERY_MONITOR is a Snowflake SQL stored procedure that is used to construct a query monitor object. This procedure is defined in the database OPSCENTER (database where Snowflake NativeApp is installed) schema ADMIN.

ACCOUNTADMIN privilege is required to run this stored procedure.

See also:: CREATE_QUERY_MONITOR, UPDATE_QUERY_MONITOR, SHOW PROCEDURES, DESCRIBE PROCEDURE

Syntax

DELETE_QUERY_MONITOR(<name>)

Arguments

<name>: string that represents query monitor name.

Returns

NULL: if a query monitor was successfully deleted.
<error>: error message text in the case of failure to delete a query monitor.

Example:

vicky#COMPUTE_WH@OPSCENTER.(no schema)>call ADMIN.DELETE_QUERY_MONITOR('cancel_all_insert_queries');
+----------------------+                                                        
| DELETE_QUERY_MONITOR |
|----------------------|
| NULL                 |
+----------------------+
1 Row(s) produced. 

vicky#COMPUTE_WH@OPSCENTER.(no schema)>call ADMIN.DELETE_QUERY_MONITOR(NULL);
+-----------------------+                                                       
| DELETE_QUERY_MONITOR  |
|-----------------------|
| Name must not be null |
+-----------------------+
1 Row(s) produced.