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:

AWAIT

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 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;