Categories:: System Functions (System Control)

SYSTEM$CANCEL_QUERY¶

Cancels the specified query (or statement) if it is currently active/running.

See also:: SYSTEM$CANCEL_ALL_QUERIES

Syntax¶

SYSTEM$CANCEL_QUERY( <query_id> )

Arguments¶

query_id: Identifier for the query to cancel. To obtain the ID for a query executed within the last 14 days, log into the web interface and go to the History page.

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:
- ALTER WAREHOUSE … ABORT ALL QUERIES
- ALTER USER … ABORT ALL QUERIES

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.    |
+-------------------------------------------------------------+