DYNAMIC_TABLE_REFRESH_HISTORY view and SHOW DYNAMIC TABLES command: New columns in output (Preview)¶
Attention
This behavior change is in the 2026_01 bundle.
For the current status of the bundle, refer to Bundle history.
When this behavior change bundle is enabled, the output of the SHOW DYNAMIC TABLES command includes the following new column:
Column name |
Data type |
Description |
|---|---|---|
initialization_warehouse |
TEXT |
The warehouse used for initializations and reinitializations. Null if no initialization warehouse is set on the dynamic table. For more information, see Understand warehouse usage for dynamic tables. |
When this behavior change bundle is enabled, the output of the DYNAMIC_TABLE_REFRESH_HISTORY table function and view includes the following new column:
Column name |
Data type |
Description |
|---|---|---|
warehouse |
TEXT |
The warehouse used for the dynamic table refresh. If the INITIALIZATION_WAREHOUSE property is SET, the specified warehouse is used for all initializations and reinitializations; otherwise, the dynamic table uses the warehouse that is specified by the WAREHOUSE property for all refreshes. For more information, see Understand warehouse usage for dynamic tables. |
Ref: 2163