SHOW TABLES and SHOW WAREHOUSES commands: New columns in output¶
Attention
This behavior change is in the 2026_01 bundle.
For the current status of the bundle, refer to Bundle history.
These columns help you to examine and monitor the objects associated with interactive tables and interactive warehouses.
When this behavior change bundle is enabled, the output of the SHOW TABLES command includes the following new column:
| Column name | Data type | Description |
|---|---|---|
| is_interactive | BOOLEAN | Whether the table is an interactive table. |
When this behavior change bundle is enabled, the output of the SHOW WAREHOUSES command includes the following new column:
| Column name | Data type | Description |
|---|---|---|
| tables | NUMBER | Number of interactive tables associated with the interactive warehouse. |
Ref: 2165