v.25.8New Feature

Allow reading specific snapshot version in table

Added setting delta_lake_snapshot_version to allow reading specific snapshot version in table engine DeltaLake. #85295 (Kseniia Sumarokova).
Added the delta_lake_snapshot_version setting to the DeltaLake table engine, enabling users to read from a specific snapshot version of a Delta Lake table.

Why it matters

This feature allows users to access data from a precise snapshot version of a Delta Lake table, which is useful for retrieving historical data states, ensuring reproducibility, or performing time-travel queries.

How to use it

To use this feature, set the delta_lake_snapshot_version setting when querying a DeltaLake table. This directs ClickHouse to read data from the specified snapshot version. For example, set the setting at the session or query level before running your query.