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.