ICEBERG_COLUMNS

Provides column information for Iceberg external tables.

Provides column information for Iceberg external tables. The information in this table is drawn from the Iceberg metadata files at query time.

Column Name	Data Type	Description
`TABLE_ID`	INTEGER	Catalog-assigned numeric value that uniquely identifies the table.
`TABLE_SCHEMA`	VARCHAR	Name of the table's schema.
`TABLE_NAME`	VARCHAR	Name of the table containing the column.
`COLUMN_ID`	VARCHAR	Catalog-assigned VARCHAR value that uniquely identifies a table column.
`COLUMN_NAME`	VARCHAR	Name of the column.
`DATA_TYPE`	VARCHAR	Column data type.
`DATA_TYPE_ID`	INTEGER	Catalog-assigned unique numeric ID of the data type.
`DATA_TYPE_LENGTH`	INTEGER	Maximum allowable length of the data type.
`CHARACTER_MAXIMUM_LENGTH`	VARCHAR	Maximum allowable length of a VARCHAR column.
`NUMERIC_PRECISION`	INTEGER	Number of significant decimal digits for a NUMERIC column.
`NUMERIC_SCALE`	INTEGER	Number of fractional digits for a NUMERIC column.
`DATETIME_PRECISION`	INTEGER	Declared precision for a TIMESTAMP column, or NULL if no precision was declared.
`INTERVAL_PRECISION`	INTEGER	Number of fractional digits retained in the seconds field of an INTERVAL column.
`IS_NULLABLE`	BOOLEAN	Whether the column can contain NULL values.
`WRITE_DEFAULT`	VARCHAR	Field value for any records written after the field was added to the schema, if the writer does not supply the field’s value.
`INITIAL_DEFAULT`	VARCHAR	Field value for all records that were written before the field was added to the schema.