Snowflake · Schema
Task
A Snowflake task, used to execute SQL code.
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| comment | string | Specifies a comment for the task. |
| finalize | string | Specifies the name of the root task that the finalizer task is associated with. |
| task_auto_retry_attempts | integer | Root task settable only. Specifies the number of automatic task graph retry attempts. Valid range is 0 to 30. When not specified, no retry would happen. |
| config | object | Task Config |
| session_parameters | object | Session Parameters for the task at runtime. |
| definition | string | The SQL definition for the task. Any one of single SQL statement, call to stored procedure, or procedural logic using Snowflake scripting. |
| predecessors | array | Specifies one or more predecessor tasks for the current task |
| task_relations | string | Displays the relationship between the root task and its corresponding finalizer tasks. |
| user_task_managed_initial_warehouse_size | string | Specifies the size of the compute resources to provision for the first run of the task. This parameter only applies to serverless tasks. |
| serverless_task_min_statement_size | string | Specifies the minimum allowed warehouse size for the serverless task. Minimum XSMALL, Maximum XXLARGE. This parameter only applies to serverless tasks. |
| serverless_task_max_statement_size | string | Specifies the maximum allowed warehouse size for the serverless task. Minimum XSMALL, Maximum XXLARGE. This parameter only applies to serverless tasks. |
| user_task_timeout_ms | integer | Specifies the time limit on a single run of the task before it times out (in milliseconds). |
| suspend_task_after_num_failures | integer | Specifies the number of consecutive failed task runs after which the current task is suspended automatically. |
| condition | string | Specifies a Boolean SQL expression condition; multiple conditions joined with AND/OR are supported |
| allow_overlapping_execution | boolean | Specifies whether to allow multiple instances of the DAG to run concurrently. |
| error_integration | string | Specifies the name of the notification integration used to communicate with Amazon SNS, MS Azure Event Grid, or Google Pub/Sub. |
| created_on | string | The time the task was created on. |
| id | string | An ID for the current task. |
| owner | string | The role that owns the task. |
| owner_role_type | string | The role type of the task owner. |
| state | string | The state of the task. Must be one of started or suspended. |
| last_committed_on | string | The time the task was last committed on. |
| last_suspended_on | string | The time the task was last suspended on. |
| database_name | string | The name of the parent database for the task. |
| schema_name | string | The name of the parent schema for the task. |