Snapshots represent commits made to DuckLake. Every snapshot performs a set of changes that alter the state of the database. Snapshots can create tables, insert or delete data, and alter schemas.
Changes can only be made to DuckLake using snapshots. Every set of changes must be accompanied by a snapshot.
Listing Snapshots
The set of snapshots can be queried using the snapshots function.
This returns a list of all snapshots and their changesets.
ATTACH 'ducklake:snapshot_test.db' AS snapshot_test;
SELECT * FROM snapshot_test.snapshots();
| snapshot_id | snapshot_time | schema_version | changes |
|---|---|---|---|
| 0 | 2025-05-26 17:03:37.746+00 | 0 | {schemas_created=[main]} |
| 1 | 2025-05-26 17:03:38.66+00 | 1 | {tables_created=[main.tbl]} |
| 2 | 2025-05-26 17:03:38.748+00 | 1 | {tables_inserted_into=[1]} |
| 3 | 2025-05-26 17:03:39.788+00 | 1 | {tables_deleted_from=[1]} |