- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
TASKS view¶
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
Organization Usage performance
When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in
Performance (Organization Usage): bound every scan on history views, list
columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.
This Organization Usage view displays a row for each task defined in each account in your organization.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column Name | Data Type | Description |
|---|---|---|
| CREATED | TIMESTAMP_LTZ | Date and time when the task was created. |
| LAST_ALTERED | TIMESTAMP_LTZ | Date and time when the task was last altered. |
| DELETED | TIMESTAMP_LTZ | Date and time when the task was dropped. NULL if the task hasn’t been dropped. |
| ID | VARCHAR | Unique identifier for each task. Note that recreating a task (using CREATE OR REPLACE TASK) essentially creates a new task with a new ID. |
| TASK_NAME | VARCHAR | Name of the task. |
| TASK_DATABASE_ID | NUMBER | Internal identifier for the database in which the task is stored. |
| TASK_DATABASE | VARCHAR | Database in which the task is stored. |
| TASK_SCHEMA_ID | NUMBER | Internal identifier for the schema in which the task is stored. |
| TASK_SCHEMA | VARCHAR | Schema in which the task is stored. |
| TASK_OWNER | VARCHAR | Role that owns the task; that is, has the OWNERSHIP privilege on the task. |
| COMMENT | VARCHAR | Comment for the task. |
| WAREHOUSE | VARCHAR | Warehouse that provides the required resources to run the task. |
| SCHEDULE | VARCHAR | Schedule for running the task. Displays NULL if no schedule is specified or the task is a triggered task. |
| PREDECESSORS | ARRAY | JSON array of any tasks identified in the AFTER parameter for the task (that is, predecessor tasks). When run successfully to completion, these tasks trigger the current task. Individual task names in the array are fully qualified (that is, they include the container database and schema names). Displays an empty array if the task has no predecessor. |
| STATE | VARCHAR | Current state of the task: started or suspended. |
| DEFINITION | VARCHAR | SQL statements executed when the task runs. |
| CONDITION | VARCHAR | Condition specified in the WHEN clause for the task. |
| ALLOW_OVERLAPPING_EXECUTION | BOOLEAN | For root tasks in a task graph, displays TRUE if overlapping execution of the task graph is explicitly allowed. For child tasks in a task graph, displays NULL. |
| ERROR_INTEGRATION | VARCHAR | Name of the notification integration used to access Amazon Simple Notification Service (SNS), Google Pub/Sub, or Microsoft Azure Event Grid to relay error notifications for the task. |
| LAST_COMMITTED | TIMESTAMP_LTZ | Timestamp when a version of the task was last set. If no version was set—that is, if the task wasn’t resumed or manually run after it was created—the value is NULL. |
| LAST_SUSPENDED | TIMESTAMP_LTZ | Timestamp when the task was last suspended. Displays the timestamps for both the root tasks and the child tasks. NULL if the task hasn’t been suspended yet. |
| OWNER_ROLE_TYPE | VARCHAR | The type of role that owns the object. Common values include ROLE, DATABASE_ROLE, APPLICATION, APPLICATION PACKAGE SHARE, USER, SHARE, and others. |
| INSTANCE_ID | NUMBER | Internal/system-generated identifier for the instance which the object belongs to. |
| CONFIG | VARCHAR | For the root task in a task graph, displays the default configuration set in the task definition with CREATE TASK or ALTER TASK. For child tasks in a task graph, displays NULL. Returns an empty string for tasks in shared databases or application instances where the consumer account differs from the provider account. |
| TASK_RELATIONS | OBJECT | JSON object describing the task relationships. Can contain: Predecessors (array of fully qualified predecessor task names), FinalizerTask (fully qualified name of the finalizer task, for root tasks that have a finalizer task), and FinalizedRootTask (fully qualified name of the root task being finalized, for finalizer tasks only). |
| TASK_RELATIONS_IDS | OBJECT | Same as TASK_RELATIONS, but displays the identifier of each related task instead of its fully qualified name. |
| LAST_SUSPENDED_REASON | VARCHAR | Reason the task was suspended. Possible values: USER_SUSPENDED, SCHEMA_OR_DATABASE_DELETED, GRANT_OWNERSHIP, SUSPENDED_DUE_TO_ERRORS, CHILD_BECAME_ROOT, FINALIZER_BECAME_ROOT, APPLICATION_IS_DISABLED, SUSPENDED_DUE_TO_OVERRUNS, REPLICATED_WITHOUT_GRANT. NULL if the task has never been suspended. |
| SUCCESS_INTEGRATION | VARCHAR | Name of the notification integration used to access Amazon Simple Notification Service (SNS), Google Pub/Sub, or Microsoft Azure Event Grid to relay success notifications for the task. |
| SCHEDULING_MODE | VARCHAR | Displays whether a serverless task is FIXED or FLEXIBLE. NULL for warehouse tasks. Note: Support for FLEXIBLE mode will end in a future release. |
| TARGET_COMPLETION_INTERVAL | VARCHAR | Target completion interval for a serverless task. Used to determine compute resource size for execution. |
| EXECUTE_AS_USER_ID | NUMBER | Internal identifier for the task’s execute-as user. NULL if the task is configured to execute as the system user (default). Can be joined with the USERS view on USER_ID together with ACCOUNT_LOCATOR. |
| OVERLAP_POLICY | VARCHAR | Overlap policy for the task. Possible values: NO_OVERLAP (task graph runs can’t execute concurrently), ALLOW_CHILD_OVERLAP (runs may execute concurrently but only one root task run at a time), ALLOW_ALL_OVERLAP (runs may execute fully concurrently; root tasks only). NULL for child tasks and finalizer tasks. |
| CREATED_BY_USER_ID | NUMBER | The identifier of the user to whom the system attributes creating the task. |
Usage notes¶
- Latency for the view may be up to 180 minutes (3 hours).
- Dropped tasks have NULL values in columns that reference the task’s predecessors, finalizer, and finalized root task (PREDECESSORS, TASK_RELATIONS, and TASK_RELATIONS_IDS). To get information about the relations of a dropped task, query the TASK_VERSIONS view view.
- The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- Background maintenance operations on metadata performed by Snowflake.