v.25.4New Feature

Support DeltaLake table engine

Support DeltaLake table engine for Azure Blob Storage. Fixes #68043. #74541 (Smita Kulkarni).
Added support for the DeltaLake table engine on Azure Blob Storage in ClickHouse.

Why it matters

This feature enables ClickHouse users to directly query DeltaLake tables stored in Azure Blob Storage, improving integration with cloud data lakes and providing seamless access to DeltaLake-managed data. It solves the problem of missing native support for DeltaLake on Azure Blob Storage, enhancing data interoperability and simplifying workflows for users leveraging cloud storage solutions.

How to use it

To use this feature, create a table in ClickHouse using the DeltaLake engine and specify Azure Blob Storage connection parameters. For example:

CREATE TABLE delta_table
(
-- column definitions
)
ENGINE = DeltaLake
SETTINGS
storage_type = 'azure_blob_storage',
azure_account_name = '<your_account_name>',
azure_account_key = '<your_account_key>',
azure_container = '<your_container>',
path = '<path_to_delta_table>'


Replace placeholders with appropriate values to connect to your Azure Blob Storage DeltaLake path.