This table contains the information used to map a name to a column_id for a given mapping_id with the map_by_name type.
| Column name | Column type | |
|---|---|---|
mapping_id |
BIGINT |
|
column_id |
BIGINT |
|
source_name |
VARCHAR |
|
target_field_id |
BIGINT |
|
parent_column |
BIGINT |
|
is_partition |
BOOLEAN |
mapping_idrefers to amapping_idfrom theducklake_column_mappingtable.column_ididentifies a column within this mapping.source_namerefers to the name of the field this mapping applies to.target_field_idrefers to the DuckLakecolumn_idthat a field with thesource_nameis mapped to.parent_columnis thecolumn_idof the parent column within this mapping. This isNULLfor top-level and non-nested columns. For example, forSTRUCTtypes, this would refer to the “parent”STRUCTcolumn.is_partitiondetermines whether a column is used for hive-partitioning.
© 2026 DuckDB Foundation, Amsterdam NL