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;