CANCEL (Snowflake Scripting)¶
Cancels an asynchronous child job that is running for a RESULTSET.
Note
This Snowflake Scripting construct is valid only within a Snowflake Scripting block.
- See also:
Syntax¶
CANCEL <result_set_name> ;
Where:
result_set_name
The name of the RESULTSET.
Usage notes¶
An asynchronous child job is created for a RESULTSET when the ASYNC keyword is specified for the query.
If the child job for the RESULTSET has already completed, the CANCEL statement has no effect.
Examples¶
CANCEL my_result_set;