DESCRIBE and SHOW commands for Apache Iceberg™ tables: New columns in output¶
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 output of the following commands includes the following new column:
- DESCRIBE ICEBERG TABLE command
- DESCRIBE TABLE command
- DESCRIBE DYNAMIC TABLE command
- SHOW COLUMNS command
| Column name | Data type | Description |
|---|---|---|
| write default | string | The write default for the column. This column is appended to the end of the output. Note For the DESCRIBE DYNAMIC TABLE command, when you base a dynamic table on an Iceberg table that has a write default defined for a column, the dynamic table doesn’t inherit the default value. However, the write default column returns in the output for the DESCRIBE DYNAMIC TABLE. command. |
When this behavior change bundle is enabled, the output of the SHOW ICEBERG TABLES command includes the following new column(s):
| Column name | Data type | Description |
|---|---|---|
| iceberg_table_format_version | integer | The version of the Apache IcebergTM table specification that the table conforms to. This column is appended to the end of the output. |
Ref: 2210