With this model, you set when you want the task to run, and Snowflake predicts and assigns compute resources needed to complete the task in that time. The prediction is based on a …

For other tasks, a schedule must be defined for a standalone task or the root task in a task graph; otherwise, the task only runs if manually executed using EXECUTE TASK.

Snowflake estimates the resources needed using the target completion interval, and adjusts to complete the task in this time. The following example creates a serverless triggered task that …

Lists the tasks for which you have access privileges. The command can be used to list tasks for the current/specified database or schema, or across your entire account.

When the root task in a task graph is resumed or manually executed, Snowflake sets a version of the entire task graph, including all properties for all tasks in the task graph.

By default, Snowflake runs tasks by using the system user with the privileges of the task owner role. To run a task as a specific user, configure the task with EXECUTE AS USER.

Select a task on the graph to view additional details, such as predecessor tasks, the warehouse used to run the task, and the role that owns the task. You can also edit the root task to change …

Manage tasks The Snowflake REST Task API provides the following endpoints to access, update, and perform certain actions on task resources in a Snowflake database:

Prerequisites The examples in this topic assume that you’ve added code to connect with Snowflake and to create a Root object from which to use the Snowflake Python APIs. For …

The compute resources for individual runs of a task are either managed by Snowflake (i.e. the serverless compute model) or a user-specified virtual warehouse. To convert a task that relies …