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

Attention

This behavior change is in the 2023_06 bundle.

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

In the current Snowflake release, the output of the task history, current task graphs, and complete task graphs views and functions 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

Previously:

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

Currently:

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 for additional related new columns.

Ref: 1279

Language: English