The ducklake_sort_info table records the version history of sort settings for tables. Each row represents one sort configuration applied to a table, with snapshot-based validity tracking.
| Column name | Column type | |
|---|---|---|
sort_id |
BIGINT |
|
table_id |
BIGINT |
|
begin_snapshot |
BIGINT |
|
end_snapshot |
BIGINT |
sort_idis a numeric identifier for a sort configuration.sort_idis allocated fromnext_catalog_idin theducklake_snapshottable.table_idrefers to atable_idfrom theducklake_tabletable.begin_snapshotrefers to asnapshot_idfrom theducklake_snapshottable. The sort configuration is valid starting with this snapshot id.end_snapshotrefers to asnapshot_idfrom theducklake_snapshottable. The sort configuration is valid up to but not including this snapshot id. Ifend_snapshotisNULL, the sort configuration is currently active.
The expressions associated with a sort configuration are stored in ducklake_sort_expression.
© 2026 DuckDB Foundation, Amsterdam NL