This table contains the valid snapshots in a DuckLake.
| Column name | Column type | |
|---|---|---|
snapshot_id |
BIGINT |
Primary Key |
snapshot_time |
TIMESTAMP |
|
schema_version |
BIGINT |
|
next_catalog_id |
BIGINT |
|
next_file_id |
BIGINT |
snapshot_idis the numeric identifier of the snapshot. It is a primary key and is referred to by various other tables below.snapshot_timeis the time stamp at which the snapshot was created.schema_versionis an continously increasing number that is incremented whenever the schema is changed, e.g. by creating a table. This allows for caching of schema information if only data is changed.next_catalog_idis a continously increasing number that descirbes the next identifier for schemas, tables and views. This is only changed if one of those entries is created, i.e., the schema is changing.next_file_idis a continously increasing number that contains the next id for a data or deletion file to be added. It is only changed if data is being added or deleted, i.e., not for schema changes.