CANCEL (Snowflake Scripting) | Snowflake Documentation (original) (raw)

Cancels an asynchronous child jobthat is running for a RESULTSET.

Note

This Snowflake Scripting construct is valid only within aSnowflake Scripting block.

See also:

AWAIT

Syntax¶

CANCEL ;

Copy

Where:

_resultsetname_

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;

Copy