- Categories:
System Functions (System Control)
SYSTEM$CANCEL_QUERY¶
Cancels the specified query (or statement) if it is currently active/running.
- See also:
Syntax¶
SYSTEM$CANCEL_QUERY( <query_id> )
Arguments¶
Usage Notes¶
Snowflake query IDs are UUID text strings with hyphens, which are special characters, so the strings must be escaped using single quotes.
This function is not intended for canceling queries for a particular warehouse or user. Instead, use:
Examples¶
SELECT SYSTEM$CANCEL_QUERY('d5493e36-5e38-48c9-a47c-c476f2111ce5');
+-------------------------------------------------------------+
| SYSTEM$CANCEL_QUERY('D5493E36-5E38-48C9-A47C-C476F2111CE5') |
|-------------------------------------------------------------|
| query [d5493e36-5e38-48c9-a47c-c476f2111ce5] terminated. |
+-------------------------------------------------------------+