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, Azure Blob Storage, or a locally mounted file system.
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/: