Dynamic tables: SHOW command and functions: new columns in output (Preview)¶
Attention
This behavior change is in the 2026_02 bundle.
For the current status of the bundle, refer to Bundle history.
When this behavior change bundle is enabled, the following dynamic table command and Information Schema table functions include new columns that provide visibility into the execution context of dynamic table refreshes.
SHOW DYNAMIC TABLES command: New columns in output¶
When this behavior change bundle is enabled, the output of the SHOW DYNAMIC TABLES command includes the following new columns:
Column name |
Data type |
Description |
|---|---|---|
EXECUTE_AS_USER |
VARCHAR |
The user that the dynamic table refresh runs as. |
SECONDARY_ROLES |
VARCHAR |
The secondary roles used during dynamic table refresh execution. |
DYNAMIC_TABLES and DYNAMIC_TABLE_GRAPH_HISTORY functions (Information Schema): New columns¶
When this behavior change bundle is enabled, the DYNAMIC_TABLES and DYNAMIC_TABLE_GRAPH_HISTORY Information Schema table functions include the following new columns:
Column name |
Data type |
Description |
|---|---|---|
EXECUTE_AS_USER |
VARCHAR |
The user that the dynamic table refresh runs as. |
SECONDARY_ROLES |
VARCHAR |
The secondary roles used during dynamic table refresh execution. |
For more information, see Refresh dynamic tables with specific user privileges and secondary roles.
Ref: 2208