Snowflake Task API

The task API from Snowflake — 10 operation(s) for task.

Documentation GitHub OpenAPI

Operations 16

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /api/v2/databases/{database}/schemas/{schema}/tasks List the tasks in a schema · List tasks #

Ask an LLM

“Which scheduled tasks are defined in this schema?”

“Can I see every task in a schema along with its state?”

Tell an agent

List all tasks in schema {schema} of database {database}.

Show me the scheduled tasks defined here.

POST /api/v2/databases/{database}/schemas/{schema}/tasks Create a scheduled task · Create a task #

Ask an LLM

“How do I schedule a SQL statement to run on a cron schedule?”

“Can a new task run after another task finishes instead of on a timer?”

Tell an agent

Create task {name} that runs {definition} on schedule {schedule}.

Create task {name} running {definition} on warehouse {warehouse}.

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name} Describe a single task · Fetch a task #

Ask an LLM

“What schedule, warehouse and SQL does this task use?”

“Can I see the full definition of one task?”

Tell an agent

Describe task {task} in {database}.{schema}.

Fetch this task's definition and state.

PUT /api/v2/databases/{database}/schemas/{schema}/tasks/{name} Create or alter a task with a full definition · Create a (or alter an existing) task #

Ask an LLM

“Can I change an existing task's schedule by resending its whole definition?”

“Do I need to pass every task property even for a small alter?”

Tell an agent

Create or update task {name} so it runs {definition} on {schedule}.

Alter task {name} to retry {task_auto_retry_attempts} times, keeping its SQL {definition}.

DELETE /api/v2/databases/{database}/schemas/{schema}/tasks/{name} Drop a task · Delete a task #

Ask an LLM

“How do I drop a task I no longer want scheduled?”

“Will deleting a task fail if it doesn't exist?”

Tell an agent destructive · confirm first

Drop task {task} from {database}.{schema}.

Delete the task I named from its schema.

POST /api/v2/databases/{database}/schemas/{schema}/tasks/{name}:execute Run a task immediately · Execute a task object #

Ask an LLM

“Can I trigger a task right now without waiting for its schedule?”

“Is there a way to rerun only the failed part of the last task graph run?”

Tell an agent

Execute task {task} in {database}.{schema} immediately.

Rerun this task, retrying the last failed run ({retryLast}).

POST /api/v2/databases/{database}/schemas/{schema}/tasks/{name}:resume Resume a suspended task · Resume a suspended task #

Ask an LLM

“How do I restart a task that is currently suspended?”

“Does a new task need to be resumed before it starts running on schedule?”

Tell an agent

Resume suspended task {task} in {database}.{schema}.

Turn the task I named back on so it follows its schedule.

POST /api/v2/databases/{database}/schemas/{schema}/tasks/{name}:suspend Suspend a running task · Suspend a running task #

Ask an LLM

“Can I pause a task so it stops firing on its schedule?”

“What's the way to temporarily stop a task without dropping it?”

Tell an agent

Suspend task {task} in {database}.{schema}.

Pause the task I named until I resume it.

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/dependents List the tasks that depend on a task · Fetch the dependent tasks of a task #

Ask an LLM

“Which child tasks run after this task in the graph?”

“Can I get every downstream task recursively, not just direct children?”

Tell an agent

List the dependent tasks of {task} in {database}.{schema}.

Show all downstream tasks of this task, recursively ({recursive}).

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/current_graphs Get running or upcoming graph runs (legacy) · Get the graph runs that are executing or scheduled for the task for the next 8… #

Ask an LLM

“Is there an older current_graphs endpoint with an underscore path?”

“What does the legacy call for scheduled graph runs return?”

Tell an agent

Use the legacy current_graphs endpoint for task {task} in {database}.{schema}.

Call the deprecated current_graphs route, capped at {resultLimit} runs.

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/current-graphs Get running and upcoming task graph runs · Get the graph runs that are executing or scheduled for the task for the next 8… #

Ask an LLM

“Which runs of this task graph are executing now or scheduled over the next 8 days?”

“Can I limit how many upcoming graph runs come back?”

Tell an agent

Show graph runs executing or scheduled soon for task {task} in {database}.{schema}.

List up to {resultLimit} current and upcoming graph runs for this task.

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/complete_graphs Get completed graph runs (legacy) · Get the graph runs that are completed for the task #

Ask an LLM

“Is there an older complete_graphs endpoint with an underscore path?”

“Does the legacy completed-runs call still filter to errors only?”

Tell an agent

Use the legacy complete_graphs endpoint for task {task} in {database}.{schema}.

Call the deprecated complete_graphs route with errorOnly set to {errorOnly}.

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name}/complete-graphs Get completed task graph runs · Get the graph runs that are completed for the task #

Ask an LLM

“Did the recent runs of this task graph succeed or fail?”

“Can I see only the completed graph runs that ended in an error?”

Tell an agent

Show the completed graph runs of task {task} in {database}.{schema}.

List the last {resultLimit} finished graph runs for this task, errors only: {errorOnly}.

POST /api/v2/databases/{database}/schemas/{schema}/tasks/{name}:set-tags Set tags on a task · Set tags on an existing task #

Ask an LLM

“How do I attach tags to a scheduled task?”

“Can I label a task with an owner or cost-center tag?”

Tell an agent

Set tags on task {task} in {database}.{schema}.

Apply my tag assignments to the task I named.

POST /api/v2/databases/{database}/schemas/{schema}/tasks/{name}:unset-tags Remove tags from a task · Unset tags from an existing task #

Ask an LLM

“Can I remove tags from a task?”

“What's the way to clear a tag off a scheduled task?”

Tell an agent

Unset the tags on task {task} in {database}.{schema}.

Remove the tag assignments from the task I named.

GET /api/v2/databases/{database}/schemas/{schema}/tasks/{name}:get-tags Get the tags assigned to a task · Get the tag assignments for the task #

Ask an LLM

“Which tags are assigned to this task?”

“Do I need a running warehouse to read a task's tags?”

Tell an agent

Show every tag assigned to task {task} in {database}.{schema}.

List the tag assignments on the task I named.

Snowflake Task API

Operations 16

Documentation

Specifications

Schemas & Data

Other Resources

Work with this as data

MCP server

Tools for apis

Call it yourself

Get an API key

OpenAPI Specification