Task views and functions (Account Usage and Information Schema): New column (Pending)

Attention

This behavior change is in the 2023_06 bundle.

For the current status of the bundle, refer to Bundle History.

In a future release, the output of the task history, current task graphs, and complete task graphs views and functions will include a new column. The affected views include:

Column Name

Data Type

Description

graph_run_group_id

NUMBER

Identifier for the graph run. When a graph run has multiple task runs, each task run will show the same graph_run_group_id. The combination of graph_run_group_id, and attempt_number can be used to uniquely identify a graph run.

Additionally, run_id behaves as follows for:

  • ACCOUNT_USAGE.TASK_HISTORY

  • ACCOUNT_USAGE.COMPLETE_TASK_GRAPHS

  • INFORMATION_SCHEMA.TASK_HISTORY

  • INFORMATION_SCHEMA:CURRENT_TASK_GRAPHS

  • INFORMATION_SCHEMA:COMPLETE_TASK_GRAPHS

Currently

run_id is unique for the current task/graph run prior to retry.

Pending

run_id may not be a unique identifier for the current task/graph run prior to retry. You may use graph_run_group_id column as a replacement for this column.

Also refer to Query and Task History views and functions: New columns (Pending) for additional related new columns.

Ref: 1279