Skip to main content
Skip to main content

Delta Lake integration

Users can integrate with the Delta lake table format via the table function.

deltaLake Table Function

Provides a read-only table-like interface to Delta Lake tables in Amazon S3 or Azure Blob Storage.

Syntax

deltaLake is an alias of deltaLakeS3, its supported for compatibility.

Arguments

Description of the arguments coincides with description of arguments in table functions s3, azureBlobStorage, HDFS and file correspondingly. format stands for the format of data files in the Delta lake table.

Returned value

A table with the specified structure for reading data in the specified Delta Lake table.

Examples

Selecting rows from the table in S3 https://clickhouse-public-datasets.s3.amazonaws.com/delta_lake/hits/:

See Also