Support matrix

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Feature Status Notes|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | **Storage backends** |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | S3 ✅ Experimental. Via [`paimon()`](/docs/sql-reference/table-functions/paimon) or `paimonS3()`| GCS ✅ Experimental. Via [`paimon()`](/docs/sql-reference/table-functions/paimon) or `paimonS3()`| Azure Blob Storage ✅ Experimental. Via [`paimonAzure()`](/docs/sql-reference/table-functions/paimon)| HDFS ⚠️ Experimental. Via [`paimonHDFS()`](/docs/sql-reference/table-functions/paimon). Deprecated.| Local filesystem ✅ Experimental. Via [`paimonLocal()`](/docs/sql-reference/table-functions/paimon)| **Access methods** |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Table function ✅ Experimental. [`paimon()`](/docs/sql-reference/table-functions/paimon) with variants per backend| Table engine ❌ No dedicated table engine|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Cluster-distributed reads ✅ Experimental. [`paimonS3Cluster`](/docs/sql-reference/table-functions/paimonCluster), [`paimonAzureCluster`](/docs/sql-reference/table-functions/paimonCluster), [`paimonHDFSCluster`](/docs/sql-reference/table-functions/paimonCluster)| Named collections ✅ Experimental. [Defining a named collection](/docs/sql-reference/table-functions/paimon#defining-a-named-collection)| **Read features** |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Read support ✅ Experimental. Full SELECT support with all ClickHouse SQL functions|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Schema evolution ❌ Not supported|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Time travel ❌ Not supported|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Virtual columns ✅ Experimental. `_path`, `_file`, `_size`, `_time`, `_etag`. See [Virtual columns](/docs/sql-reference/table-functions/paimon#virtual-columns).| **Write features** |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | INSERT / DELETE / UPDATE ❌ Read-only integration|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | **Caching** |  |  |  | | --- | --- | --- | | Data caching ❌ Not supported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

## Catalog support[​](#catalog-support "Direct link to Catalog support")

ClickHouse can connect to external data catalogs using the [`DataLakeCatalog`](/docs/engines/database-engines/datalakecatalog) database engine, which exposes the catalog as a ClickHouse database. Tables registered in the catalog appear automatically and can be queried with standard SQL.

The following catalogs are currently supported. Refer to each catalog's reference guide for full setup instructions.

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Catalog Formats Read Create table INSERT Reference guide|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [AWS Glue Catalog](/docs/use-cases/data-lake/glue-catalog) Iceberg ✅ Beta ❌ ❌ [Glue catalog guide](/docs/use-cases/data-lake/glue-catalog)| [BigLake Metastore](/docs/use-cases/data-lake/biglake-catalog) Iceberg ✅ Beta ❌ ❌ [BigLake Metastore guide](/docs/use-cases/data-lake/biglake-catalog)| [Databricks Unity Catalog](/docs/use-cases/data-lake/unity-catalog) Delta, Iceberg ✅ Experimental ❌ ❌ [Unity Catalog guide](/docs/use-cases/data-lake/unity-catalog)| [Iceberg REST](/docs/use-cases/data-lake/rest-catalog) Iceberg ✅ Beta ❌ ❌ [REST catalog guide](/docs/use-cases/data-lake/rest-catalog)| [Lakekeeper](/docs/use-cases/data-lake/lakekeeper-catalog) Iceberg ✅ Experimental ❌ ❌ [Lakekeeper catalog guide](/docs/use-cases/data-lake/lakekeeper-catalog)| [Project Nessie](/docs/use-cases/data-lake/nessie-catalog) Iceberg ✅ Experimental ❌ ❌ [Nessie catalog guide](/docs/use-cases/data-lake/nessie-catalog)| [Microsoft OneLake](/docs/use-cases/data-lake/onelake-catalog) Iceberg ✅ Beta ❌ ❌ [OneLake catalog guide](/docs/use-cases/data-lake/onelake-catalog) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

All catalog integrations currently require an experimental or beta setting to be enabled and expose **read-only** access — tables can be queried but not created or written to through the catalog connection. To load data from a catalog into ClickHouse for faster analytics, use `INSERT INTO SELECT` as described in the [accelerating analytics guide](/docs/use-cases/data-lake/getting-started/accelerating-analytics). To write data back to open table formats, create standalone Iceberg tables as described in the [writing data guide](/docs/use-cases/data-lake/getting-started/writing-data).

- [Open table format support](#format-support)- [Catalog support](#catalog-support)

Was this page helpful?