Submit Asynchronous SQL Statement
A 2-step recipe with Snowflake. We can help you get access.
Recipe · 2 steps
Submit Asynchronous SQL Statement
with Snowflake
Submit a SQL statement asynchronously and read back its execution status.
- Submit the SQL statement with async=true. The API returns a 202 with the statement handle that uniquely identifies the running statement.
- Check the execution status of the asynchronous statement by its handle. A 202 indicates the statement is still running; a 200 indicates completion with a result set.
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 execute 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:submit-async-sql-statement, 2 operations: submitStatement → getStatementStatus. Specs on APIs.io.