This table defines which data file belongs to which partition.
| Column name | Column type | |
|---|---|---|
data_file_id |
BIGINT |
|
table_id |
BIGINT |
|
partition_key_index |
BIGINT |
|
partition_value |
VARCHAR |
data_file_idrefers to adata_file_idfrom theducklake_data_filetable.table_idrefers to atable_idfrom theducklake_tabletable.partition_key_indexrefers to apartition_key_indexfrom theducklake_partition_columntable.partition_valueis the transformed partition value that all the rows in the data file have, encoded as a string.
For example, epoch_month stores 600 for dates in January 2020, whereas month stores 1.
© 2026 DuckDB Foundation, Amsterdam NL