COMPLETE_TASK_GRAPHS view | Snowflake Documentation

Schema:: ORGANIZATION_USAGE

You can use the Organization Usage view to query the status of completed graph runs, such as runs that executed successfully, failed, or were cancelled. A graph is currently defined as a single scheduled task or a task graph composed of a scheduled root task and one or more child tasks. For the purposes of this function, root task refers to either the single scheduled task or the root task in a task graph.

The view avoids the 10,000 row limitation of the COMPLETE_TASK_GRAPHS.

Columns¶

Organization-level columns

Additional columns

Usage notes¶

Latency for the view may be up to 24 hours.

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 organization:

SELECT account_name, root_task_name, state
FROM snowflake.organization_usage.complete_task_graphs
  LIMIT 10;