Cancel a Running SQL Statement
A 2-step recipe with Snowflake. We can help you get access.
Recipe · 2 steps
Cancel a Running SQL Statement
with Snowflake
Launch a SQL statement asynchronously and cancel it by its statement handle.
- Submit the statement asynchronously so the API returns a 202 with the statement handle to cancel.
- Cancel the execution of the statement identified by the handle. A 200 indicates the execution was successfully canceled.
What you'll need to have ready
- authToken: Bearer token (KEYPAIR_JWT, OAUTH, or programmatic access token).
- tokenType: Value for the X-Snowflake-Authorization-Token-Type header.
- statement: The SQL statement to submit asynchronously.
- warehouse: Warehouse to use when executing the statement.
- database: Database in which the statement should be executed.
- schema: Schema in which the statement should be executed.
For your developer
Arazzo workflow snowflake:cancel-running-statement, 2 operations: submitStatement → cancelStatement. Specs on APIs.io.