- Schema:
COMPLETE_TASK_GRAPHS View¶
This Account Usage view can be used to query the status of completed graph runs (i.e. runs that executed successfully, failed, or were cancelled). A graph is currently defined as a single scheduled task or a DAG of tasks composed of a scheduled root task and one or more child tasks (i.e. tasks that have a defined predecessor task). For the purposes of this function, root task refers to either the single scheduled task or the root task in a DAG.
The view avoids the 10,000 row limitation of the COMPLETE_TASK_GRAPHS.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
ROOT_TASK_NAME |
TEXT |
Name of the root task. |
DATABASE_NAME |
TEXT |
Name of the database that contains the graph. |
SCHEMA_NAME |
TEXT |
Name of the schema that contains the graph. |
STATE |
TEXT |
State of the graph run:
Note that if the state of the root task run is SKIPPED, the function does not return a row for the run. |
FIRST_ERROR_TASK_NAME |
TEXT |
Name of the first task in the graph that returned an error; returns NULL if no task produced an error. |
FIRST_ERROR_CODE |
NUMBER |
Error code of the error returned by the task named in FIRST_ERROR_TASK_NAME; returns NULL if no task produced an error. |
FIRST_ERROR_MESSAGE |
TEXT |
Error message of the error returned by the task named in FIRST_ERROR_TASK_NAME; returns NULL if no task produced an error. |
SCHEDULED_TIME |
TIMESTAMP_LTZ |
Time when the root task was scheduled to start running. Note that we make a best effort to ensure absolute precision, but only guarantee that tasks do not execute before the scheduled time. |
QUERY_START_TIME |
TIMESTAMP_LTZ |
Time when the query in the root task definition started to run. This timestamp aligns with the start time for the query returned by QUERY_HISTORY. |
NEXT_SCHEDULED_TIME |
TIMESTAMP_LTZ |
Time when the standalone or root task (in a DAG of tasks) is next scheduled to start running, assuming the current run of the standalone task or DAG started at the SCHEDULED_TIME time completes in time. |
COMPLETED_TIME |
TIMESTAMP_LTZ |
Time when the last task in the DAG was completed. |
ROOT_TASK_ID |
TEXT |
Unique identifier for the root task in a DAG. This ID matches the ID column value in the SHOW TASKS output for the same task. |
GRAPH_VERSION |
NUMBER |
Integer identifying the version of the DAG that was run, or is scheduled to be run. |
RUN_ID |
NUMBER |
Time when the standalone or root task in a DAG is/was originally scheduled to start running. Format is epoch time (in milliseconds). The combination of the ROOT_TASK_ID and RUN_ID values identifies a specific run of a DAG. . Original scheduled time refers to rare instances when the system may reschedule the same task to run at a different time to retry it or rebalance the load. If that happens, RUN_ID shows the original scheduled run time and SCHEDULED_TIME shows the rescheduled run time. |
ATTEMPT_NUMBER |
NUMBER |
Integer representing the number of attempts to run this task. Initially one. |
CONFIG |
TEXT |
Displays the graph level configuration used during the graph run if explicitly set. Otherwise displays NULL. |
Usage Notes¶
Latency for the view may be up to 45 minutes.
The view only displays objects for which the current role for the session has been granted access privileges.
Examples¶
Retrieve records for the 10 most recent task graph runs completed in your account:
select root_task_name, state from snowflake.account_usage.complete_task_graphs
limit 10;