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_nameThe name of the RESULTSET.
Usage notes¶
An asynchronous child job is created for a RESULTSET when the ASYNC keyword is specified for the query that is associated with the RESULTSET.
If the child job for the RESULTSET has already completed, the CANCEL statement has no effect.
Examples¶
CANCEL my_result_set;