This table lists changes that happened in a snapshot for easier conflict detection.
| Column name | Column type | |
|---|---|---|
snapshot_id |
BIGINT |
Primary key |
changes_made |
VARCHAR |
|
author |
VARCHAR |
|
commit_message |
VARCHAR |
|
commit_extra_info |
VARCHAR |
The ducklake_snapshot_changes table contains a summary of changes made by a snapshot. This table is used during Conflict Resolution to quickly find out if two snapshots have conflicting changesets.
snapshot_idrefers to asnapshot_idfrom theducklake_snapshottable.changes_madeis a comma-separated list of high-level changes made by the snapshot. The values that are contained in this list have the following format:created_schema:schema_path: the snapshot created a schema with the given path.created_table:schema_path.table_name: the snapshot created a table with the given name.created_view:schema_path.view_name: the snapshot created a view with the given name.created_scalar_macro:schema_path.macro_name: the snapshot created a scalar macro.created_table_macro:schema_path.macro_name: the snapshot created a table macro.inserted_into_table:table_id: the snapshot inserted data into the given table.deleted_from_table:table_id: the snapshot deleted data from the given table.compacted_table:table_id: the snapshot ran a compaction operation on the given table. Written only by older DuckLake versions.merge_adjacent:table_id: the snapshot merged adjacent files of the given table.rewrite_delete:table_id: the snapshot rewrote files to remove deleted rows.inlined_insert:table_id: the snapshot inserted inlined rows.inlined_delete:table_id: the snapshot recorded inlined deletions.inline_flush:table_id: the snapshot flushed inlined data.dropped_schema:schema_id: the snapshot dropped the given schema.dropped_table:table_id: the snapshot dropped the given table.dropped_view:view_id: the snapshot dropped the given view.dropped_scalar_macro:macro_id: the snapshot dropped a scalar macro.dropped_table_macro:macro_id: the snapshot dropped a table macro.altered_table:table_id: the snapshot altered the given table.altered_view:view_id: the snapshot altered the given view.
authoris the author of the snapshot.commit_messageis the commit message associated with the snapshot.commit_extra_infocontains extra information regarding the commit.
Names are written in quoted-format using SQL-style escapes, i.e., the name
this "table" contains quotesis written as"this ""table"" contains quotes".
Schema paths include all parent schema names, without the catalog name. For example, a table in a nested schema is recorded as created_table:"sales"."europe"."orders".
Snapshot expiration keeps rows in ducklake_snapshot_changes after removing the corresponding rows from ducklake_snapshot.
© 2026 DuckDB Foundation, Amsterdam NL