Create, Resume, and Execute a Task
A 4-step recipe with Snowflake. We can help you get access.
Recipe · 4 steps
Create, Resume, and Execute a Task
with Snowflake
Create a task, resume it, execute it once, then fetch it to confirm state.
- Create the task with its SQL definition and warehouse.
- Resume the task so it transitions out of its initial suspended state.
- Trigger a single on-demand execution of the task.
- Describe the task to confirm its current state.
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.
- databaseName: Database that holds the schema and task.
- schemaName: Schema that holds the task.
- taskName: Name of the task to create.
- warehouse: Warehouse used to run the task.
- definition: The SQL statement the task executes.
- comment: Optional comment applied to the task.
For your developer
Arazzo workflow snowflake:create-and-execute-task, 4 operations: createTask → resumeTask → executeTask → fetchTask. Specs on APIs.io.