Search Shortcut cmd + k | ctrl + k
- Documentation
- Overview
- Specification
- Introduction
- Data Types
- Queries
- Tables
- Overview
- column
- column_mapping
- column_tag
- data_file
- delete_file
- file_column_stats
- file_partition_value
- file_variant_stats
- files_scheduled_for_deletion
- inlined_data_tables
- macro
- macro_impl
- macro_parameters
- metadata
- name_mapping
- partition_column
- partition_info
- schema
- schema_versions
- snapshot
- snapshot_changes
- sort_expression
- sort_info
- table
- table_column_stats
- table_stats
- tag
- view
- 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
- Logging
- 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_schema_versions
This table contains the schema versions for a range of snapshots. It is necessary to compact files with different schemas.
| Column name | Column type | |
|---|---|---|
begin_snapshot |
BIGINT |
|
schema_version |
BIGINT |
|
table_id |
BIGINT |
begin_snapshotrefers to asnapshot_idin theducklake_snapshottable.schema_versionrefers to theschema_versionof aducklake_snapshot.table_idrefers to the id of the table, allowing to track the schema changes per table.