Get Asynchronous Query Execution Results

Project compatibility

Windows | Cross-platform

Overview

Description	API Method	API Path
Retrieves the result set for a previously executed asynchronous Snowflake query using its Query ID.	GET	/executeAsyncQuery/{queryID}/results

Input

Parameter	Description	Data Type
Query ID	Enter the query statement's unique execution ID, then select Generate output schema. You can use the output Query ID from Execute Any Query Asynchronously to generate the schema. You can then replace the Query ID with a variable once the schema is successfully generated.	string
Generate output schema	The schema generate button	string
Additional conditions	Include additional conditions such as WHERE clauses and ORDER BY to refine the results. Example: COLUMN_1='value' ORDER BY COLUMN_2 DESC	string
Offset	The number of records to skip before returning results.	integer
Limit	The number of records to return. A maximum of 200 records can be fetched per request.	integer

Note:

If you update the query, regenerate the schema for it to function accurately. If you just add or update variables in the query, there is no need to re-generate the schema.

Output

Parameter	Description	Data Type
Query results	Retrieve results by Query ID	Object

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.