INFORMATION_
Attention
This behavior change is in the 2026_06 bundle.
For the current status of the bundle, refer to Bundle history.
When this behavior change bundle is enabled, the output of the INFORMATION_SCHEMA.DYNAMIC_TABLES() table function includes the following new column:
| Column name | Data type | Description |
|---|---|---|
| RECOMMENDATIONS | OBJECT | Actionable, automated insights on how to optimize the performance, cost, or configuration of the dynamic table. |
If you have automated scripts or BI tools that query INFORMATION_SCHEMA.DYNAMIC_TABLES() and rely on a strict column count or position-based schema matching (for example, SELECT *), update your queries to handle this new column safely.
Ref: 2381