v.25.6New Feature

Add support for querying local filesystem-mounted Delta

Add support for querying local filesystem-mounted Delta tables via deltaLakeLocal table function. #79781 (roykim98).
Added support for querying Delta tables mounted on the local filesystem using the deltaLakeLocal table function.

Why it matters

This feature enables users to directly query Delta Lake tables stored locally without requiring a separate Delta Lake infrastructure or cluster. It simplifies data access and integration by allowing ClickHouse to read Delta tables from the local filesystem, enhancing interoperability and reducing setup complexity.

How to use it

Use the deltaLakeLocal table function in your queries to specify the path of the local Delta table. For example:

SELECT * FROM deltaLakeLocal(path => '/path/to/delta/table')

This allows ClickHouse to read data stored in the specified Delta Lake format locally.