Get Asynchronous Query Execution Status

Get Asynchronous Query Execution Status activity in the Snowflake connector.

Project compatibility

Windows | Cross-platform

Overview

Description	API Method	API Path
Retrieves the status of an asynchronous Snowflake query using its Query ID.	GETBYID	/executeAsyncQuery/{queryID}/status

Input

Parameter	Description	Data Type
Query ID	The query statement's unique execution ID. You can use the output Query ID from Execute Any Query Asynchronously.	string

Output

Parameter	Description	Data Type
Query execution status		Object
Status	The query execution status	string

Status values

The Status field can be one of the following:

• SUCCESS - The query finished successfully.
• RUNNING - The query is still running.
• QUEUED - The query is queued for execution (that is, hasn't yet started running), typically because it is waiting for resources.
• BLOCKED - The query is waiting on a lock held by another statement.
• RESUMING_WAREHOUSE - The warehouse is starting up, and the query isn't yet running.
• FAILED_WITH_ERROR - The query finished unsuccessfully due to an error in the query.
• FAILED_WITH_INCIDENT - The query finished unsuccessfully due to an incident on the server side.

Note:

• In API workflows, a single response object is returned as the output. Any required fields can be extracted directly from this object.
• In RPA workflows, some output parameters may differ, but the necessary values can still be retrieved from the response object even if they are not explicitly exposed.