Search Shortcut cmd + k | ctrl + k
- Documentation
- Specification
- Introduction
- Data Types
- Queries
- Tables
- Overview
- column
- column_mapping
- name_mapping
- column_tag
- data_file
- delete_file
- file_column_stats
- file_variant_stats
- file_partition_value
- files_scheduled_for_deletion
- inlined_data_tables
- metadata
- partition_column
- partition_info
- schema
- schema_versions
- snapshot
- snapshot_changes
- table
- table_column_stats
- table_stats
- tag
- view
- macro
- macro_impl
- macro_parameters
- sort_info
- sort_expression
- DuckDB Extension
- Introduction
- Usage
- Connecting
- Choosing a Catalog Database
- Choosing Storage
- Snapshots
- Schema Evolution
- Time Travel
- Upserting
- Configuration
- Paths
- Maintenance
- Recommended Maintenance
- Merge Files
- Expire Snapshots
- Cleanup of Files
- Rewrite Files with Deletes
- Checkpoint
- Advanced Features
- Constraints
- Conflict Resolution
- Data Change Feed
- Data Inlining
- Encryption
- Partitioning
- Transactions
- Row Lineage
- Macros
- Views
- Comments
- Sorted Tables
- Metadata
- Migrations
- Guides
- Overview
- Access Control
- Backups and Recovery
- Public DuckLake on Object Storage
- Using a Remote Data Path
- Troubleshooting
- Unsupported Features
- FAQ
Documentation
/ Specification
/ Tables
ducklake_snapshot
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 continuously increasing numeric identifier of the snapshot. It is a primary key and is referred to by various other tables.snapshot_timeis the timestamp at which the snapshot was created.schema_versionis a continuously 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 continuously increasing number that describes the next identifier for schemas, tables, views, partitions, and column name mappings. This is only changed if one of those entries is created, i.e., the schema is changing.next_file_idis a continuously 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.