Set up docs MCPClickHouse Cloud can connect directly to your open table format data catalogs, giving you access to your data lake tables without duplicating data. Through the integration, your catalog’s tables will appear as queryable databases inside ClickHouse. Setup is available both via SQL command (DataLakeCatalog) and via the ClickHouse Cloud UI on the Data Sources tab.
Using the UI:
- Simplifies setup with a form using fields consistent with your Data Catalog objects
- Provides a single interface for active data catalog integrations
- Tests connections and credentials when saving
For a step-by-step Cloud UI walkthrough, see Connect a data catalog in ClickHouse Cloud.
| Name | Open table format | Auth method | Cloud | Core | Version |
|---|---|---|---|---|---|
| AWS Glue Catalog | Iceberg | IAM role (26.2+), Access keys | Guide | Guide | 25.12+ |
| BigLake Metastore | Iceberg | Google ADC (OAuth) | Guide | Guide | 26.2+ |
| Lakekeeper | Iceberg | OAuth client credentials | — | Guide | 25.10+ |
| Microsoft OneLake | Iceberg | Azure Active Directory (AAD) | Guide | Guide | 25.12+ |
| Nessie | Iceberg | OAuth client credentials | — | Guide | 25.10+ |
| Polaris | Iceberg | OAuth client credentials | Guide | Guide | 26.2+ |
| Horizon | Iceberg | PAT / JWT / bearer token | — | Guide | — |
| REST catalog | Iceberg | OAuth client credentials, Bearer token | Guide | Guide | 25.12+ |
| Unity Catalog | Iceberg | OAuth client credentials | Guide | Guide | 25.12+ |
| Unity Catalog | Delta | Personal Access Token (PAT) | Guide | Guide | 25.12+ |
We have more catalogs planned, including the S3 Tables REST endpoint.