> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-trino-dialect.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Support matrix

> Comprehensive support matrices for ClickHouse open table format integrations and data catalog connections.

This page provides comprehensive support matrices for ClickHouse's data lake integrations. It covers the features available for each open table format, the catalogs ClickHouse can connect to, and the capabilities supported by each catalog.

Support is shown separately for ClickHouse Cloud and self-managed ClickHouse. Experimental features are disabled by default in ClickHouse Cloud and [must be requested through Support](https://clickhouse.com/blog/common-getting-started-issues-with-clickhouse#13-experimental-features-in-production). Availability is feature-dependent, so contact Support to confirm whether a specific experimental feature can be enabled. Deployment-specific configuration and limitations are described in the Notes column.

<h2 id="format-support">
  Open table format support
</h2>

ClickHouse integrates with four open table formats: [Apache Iceberg](/reference/engines/table-engines/integrations/iceberg), [Delta Lake](/reference/engines/table-engines/integrations/deltalake), [Apache Hudi](/reference/engines/table-engines/integrations/hudi), and [Apache Paimon](/reference/functions/table-functions/paimon). Select a format below to view its support matrix.

**Legend:** ✅ Supported | ⚠️ Partial, experimental, or deprecated | ❌ Not supported

<Tabs>
  <Tab title="Apache Iceberg">
    | Feature                        |                       ClickHouse Cloud                       |  Self-managed | Notes                                                                                                                                                                                                                                |
    | ------------------------------ | :----------------------------------------------------------: | :-----------: | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
    | **Storage backends**           |                                                              |               |                                                                                                                                                                                                                                      |
    | AWS S3                         |                               ✅                              |       ✅       | Via [`icebergS3()`](/reference/functions/table-functions/iceberg) or `iceberg()` alias                                                                                                                                               |
    | GCS                            |                               ✅                              |       ✅       | Via [`icebergS3()`](/reference/functions/table-functions/iceberg) or `iceberg()` alias                                                                                                                                               |
    | Azure Blob Storage             |                               ✅                              |       ✅       | Via [`icebergAzure()`](/reference/functions/table-functions/iceberg)                                                                                                                                                                 |
    | HDFS                           |                               ❌                              | ⚠️ Deprecated | Via [`icebergHDFS()`](/reference/functions/table-functions/iceberg)                                                                                                                                                                  |
    | Local filesystem               |                               ❌                              |       ✅       | Via [`icebergLocal()`](/reference/functions/table-functions/iceberg)                                                                                                                                                                 |
    | **Access methods**             |                                                              |               |                                                                                                                                                                                                                                      |
    | Table function                 |                               ✅                              |       ✅       | [`icebergS3()`](/reference/functions/table-functions/iceberg) with variants per backend                                                                                                                                              |
    | Table engine                   |                               ✅                              |       ✅       | [`IcebergS3`](/reference/engines/table-engines/integrations/iceberg) with variants per backend                                                                                                                                       |
    | Cluster-distributed reads      |                               ✅                              |       ✅       | [`icebergS3Cluster`](/reference/functions/table-functions/icebergCluster), [`icebergAzureCluster`](/reference/functions/table-functions/icebergCluster), [`icebergHDFSCluster`](/reference/functions/table-functions/icebergCluster) |
    | Named collections              | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ✅       | DDL-created [named collections](/concepts/features/configuration/server-config/named-collections) can be enabled on select ClickHouse Cloud services. Contact Support to confirm availability.                                       |
    |                                |                                                              |               |                                                                                                                                                                                                                                      |
    | **Read features**              |                                                              |               |                                                                                                                                                                                                                                      |
    | Read support                   |                               ✅                              |       ✅       | Full `SELECT` support with all ClickHouse SQL functions                                                                                                                                                                              |
    | Partition pruning              |                               ✅                              |       ✅       | See [Partition pruning](/reference/engines/table-engines/integrations/iceberg#partition-pruning).                                                                                                                                    |
    | Hidden partitioning            |                               ✅                              |       ✅       | Iceberg transform-based partitioning supported                                                                                                                                                                                       |
    | Partition evolution            |                               ✅                              |       ✅       | Reading tables with changing partition specs over time supported                                                                                                                                                                     |
    | Schema evolution               |                               ✅                              |       ✅       | Column addition, removal, and reordering. See [Schema evolution](/reference/engines/table-engines/integrations/iceberg#schema-evolution).                                                                                            |
    | Type promotion / widening      |                               ✅                              |       ✅       | `int` → `long`, `float` → `double`, `decimal(P,S)` → `decimal(P',S)` where P' > P. See [Schema evolution](/reference/engines/table-engines/integrations/iceberg#schema-evolution).                                                   |
    | Time travel / snapshots        |                               ✅                              |       ✅       | Via `iceberg_timestamp_ms` or `iceberg_snapshot_id` settings. See [Time travel](/reference/engines/table-engines/integrations/iceberg#time-travel).                                                                                  |
    | Position deletes               |                               ✅                              |       ✅       | See [Processing deleted rows](/reference/engines/table-engines/integrations/iceberg#deleted-rows).                                                                                                                                   |
    | Equality deletes               |                               ✅                              |       ✅       | Table functions and table engines, from v25.8+. See [Processing deleted rows](/reference/engines/table-engines/integrations/iceberg#deleted-rows).                                                                                   |
    | Merge-on-read                  | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Supported for [delete operations](/reference/functions/table-functions/iceberg#iceberg-writes-delete).                                                                                                                 |
    | Format versions                |                          ⚠️ Partial                          |   ⚠️ Partial  | v1 and v2 are supported. V3 support is partial; deletion vectors and manifest compaction aren't supported.                                                                                                                           |
    | Column statistics              |                               ✅                              |       ✅       |                                                                                                                                                                                                                                      |
    | Bloom filters / puffin files   |                               ❌                              |       ❌       | Bloom filter indexes in Puffin files aren't supported                                                                                                                                                                                |
    | Virtual columns                |                               ✅                              |       ✅       | `_path`, `_file`, `_size`, `_time`, `_etag`. See [Virtual columns](/reference/functions/table-functions/iceberg#virtual-columns).                                                                                                    |
    |                                |                                                              |               |                                                                                                                                                                                                                                      |
    | **Write features**             |                                                              |               |                                                                                                                                                                                                                                      |
    | Table creation                 | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Requires `allow_insert_into_iceberg = 1`. From v25.7+. See [Creating a table](/reference/functions/table-functions/iceberg#create-iceberg-table).                                                                      |
    | `INSERT`                       |                            ✅ Beta                            |     ✅ Beta    | Beta from 26.2. Requires `allow_insert_into_iceberg = 1`. See [Inserting data](/reference/functions/table-functions/iceberg#writes-inserts).                                                                                         |
    | `DELETE`                       | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Requires `allow_insert_into_iceberg = 1`. Via `ALTER TABLE ... DELETE WHERE`. See [Deleting data](/reference/functions/table-functions/iceberg#iceberg-writes-delete).                                                 |
    | `ALTER TABLE` (schema changes) | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Requires `allow_insert_into_iceberg = 1`. Add, drop, modify, rename columns. See [Schema evolution](/reference/functions/table-functions/iceberg#iceberg-writes-schema-evolution).                                     |
    | Compaction                     | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Requires `allow_experimental_iceberg_compaction = 1`. See [Compaction](/reference/functions/table-functions/iceberg#iceberg-writes-compaction).                                                                        |
    | `UPDATE` / `MERGE`             |                               ❌                              |       ❌       | Not supported. See Compaction.                                                                                                                                                                                                       |
    | Copy-on-write                  |                               ❌                              |       ❌       | Not supported                                                                                                                                                                                                                        |
    | Expire snapshots               | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Requires Iceberg v2, `allow_insert_into_iceberg = 1`, and `allow_experimental_expire_snapshots = 1`. See [Expire snapshots](/reference/functions/table-functions/iceberg#iceberg-expire-snapshots).                    |
    | Remove orphan files            | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ⚠️      | Experimental. Requires Iceberg v2 or higher, `allow_insert_into_iceberg = 1`, and `allow_iceberg_remove_orphan_files = 1`. See [Remove orphan files](/reference/functions/table-functions/iceberg#iceberg-remove-orphan-files).      |
    | Writing partitions             |                            ✅ Beta                            |     ✅ Beta    | Supported for Iceberg writes.                                                                                                                                                                                                        |
    | Altering partitions            |                               ❌                              |       ❌       | Changing the partitioning scheme from ClickHouse isn't supported. ClickHouse can write to Iceberg tables with an evolved partitioning scheme.                                                                                        |
    |                                |                                                              |               |                                                                                                                                                                                                                                      |
    | **Metadata**                   |                                                              |               |                                                                                                                                                                                                                                      |
    | Branching and tagging          |                               ❌                              |       ❌       | Iceberg branch/tag references aren't supported                                                                                                                                                                                       |
    | Metadata file resolution       |                               ✅                              |       ✅       | Supports resolution through catalogs, directory listing, `version-hint`, and a specific path. See [Metadata file resolution](/reference/engines/table-engines/integrations/iceberg#metadata-file-resolution).                        |
    | Data caching                   |                               ✅                              |       ✅       | Same mechanism as S3/Azure/HDFS storage engines. See [Data cache](/reference/engines/table-engines/integrations/iceberg#data-cache).                                                                                                 |
    | Metadata caching               |                               ✅                              |       ✅       | Enabled by default via `use_iceberg_metadata_files_cache`. See [Metadata cache](/reference/engines/table-engines/integrations/iceberg#metadata-cache).                                                                               |
  </Tab>

  <Tab title="Delta Lake">
    From version 25.6, ClickHouse reads Delta Lake tables using the Delta Lake Rust kernel, providing broader feature support; however, known issues occur when accessing data in Azure Blob Storage. For this reason the Kernel is disabled when reading data on Azure Blob Storage. We indicate below which features require this kernel.

    | Feature                       |                       ClickHouse Cloud                       | Self-managed | Notes                                                                                                                                                                                                                                                                                                          |
    | ----------------------------- | :----------------------------------------------------------: | :----------: | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | **Storage backends**          |                                                              |              |                                                                                                                                                                                                                                                                                                                |
    | AWS S3                        |                               ✅                              |       ✅      | Via [`deltaLake()`](/reference/functions/table-functions/deltalake) or `deltaLakeS3()`                                                                                                                                                                                                                         |
    | GCS                           |                               ✅                              |       ✅      | Via [`deltaLake()`](/reference/functions/table-functions/deltalake) or `deltaLakeS3()`                                                                                                                                                                                                                         |
    | Azure Blob Storage            |                               ✅                              |       ✅      | Via [`deltaLakeAzure()`](/reference/functions/table-functions/deltalake)                                                                                                                                                                                                                                       |
    | HDFS                          |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                                                                                                                                  |
    | Local filesystem              |                               ❌                              |       ✅      | Via [`deltaLakeLocal()`](/reference/functions/table-functions/deltalake)                                                                                                                                                                                                                                       |
    | **Access methods**            |                                                              |              |                                                                                                                                                                                                                                                                                                                |
    | Table function                |                               ✅                              |       ✅      | [`deltaLake()`](/reference/functions/table-functions/deltalake) with variants per backend                                                                                                                                                                                                                      |
    | Table engine                  |                               ✅                              |       ✅      | [`DeltaLake`](/reference/engines/table-engines/integrations/deltalake)                                                                                                                                                                                                                                         |
    | Cluster-distributed reads     |                               ✅                              |       ✅      | [`deltaLakeCluster`](/reference/functions/table-functions/deltalakeCluster), [`deltaLakeAzureCluster`](/reference/functions/table-functions/deltalakeCluster)                                                                                                                                                  |
    | Named collections             | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ✅      | DDL-created [named collections](/concepts/features/configuration/server-config/named-collections) can be enabled on select ClickHouse Cloud services. Contact Support to confirm availability.                                                                                                                 |
    | **Read features**             |                                                              |              |                                                                                                                                                                                                                                                                                                                |
    | Read support                  |                               ✅                              |       ✅      | Full `SELECT` support with all ClickHouse SQL functions                                                                                                                                                                                                                                                        |
    | Partition pruning             |                            ✅ Beta                            |    ✅ Beta    | Requires the Delta Kernel.                                                                                                                                                                                                                                                                                     |
    | Schema evolution              |                            ✅ Beta                            |    ✅ Beta    | Requires the Delta Kernel.                                                                                                                                                                                                                                                                                     |
    | Time travel                   |                            ✅ Beta                            |    ✅ Beta    | Requires the Delta Kernel.                                                                                                                                                                                                                                                                                     |
    | Deletion vectors              |                               ✅                              |       ✅      |                                                                                                                                                                                                                                                                                                                |
    | Column mapping                |                               ✅                              |       ✅      |                                                                                                                                                                                                                                                                                                                |
    | Change data feed              |                            ✅ Beta                            |    ✅ Beta    | Requires the Delta Kernel.                                                                                                                                                                                                                                                                                     |
    | Virtual columns               |                               ✅                              |       ✅      | `_path`, `_file`, `_size`, `_time`, `_etag`. See [Virtual columns](/reference/functions/table-functions/deltalake#virtual-columns).                                                                                                                                                                            |
    | **Write features**            |                                                              |              |                                                                                                                                                                                                                                                                                                                |
    | `INSERT`                      |                            ✅ Beta                            |    ✅ Beta    | Requires the Delta Kernel. Writes are supported for S3 and GCS; Azure writes aren't supported. Requires `allow_delta_lake_writes = 1` from v26.7; on earlier versions, use `allow_experimental_delta_lake_writes = 1`. See [Delta Lake writes](/reference/functions/table-functions/deltalake#inserting-data). |
    | `DELETE` / `UPDATE` / `MERGE` |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                                                                                                                                  |
    | Create empty table            |                               ❌                              |       ❌      | The `CREATE TABLE` operation assumes that the Delta Lake table already exists on object storage.                                                                                                                                                                                                               |
    | **Caching**                   |                                                              |              |                                                                                                                                                                                                                                                                                                                |
    | Data caching                  |                               ✅                              |       ✅      | Same mechanism as S3/Azure/HDFS storage engines. See [Data cache](/reference/engines/table-engines/integrations/deltalake#data-cache).                                                                                                                                                                         |
  </Tab>

  <Tab title="Apache Hudi">
    | Feature                        |                       ClickHouse Cloud                       | Self-managed | Notes                                                                                                                                                                                          |
    | ------------------------------ | :----------------------------------------------------------: | :----------: | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | **Storage backends**           |                                                              |              |                                                                                                                                                                                                |
    | AWS S3                         |                               ✅                              |       ✅      | Via [`hudi()`](/reference/functions/table-functions/hudi)                                                                                                                                      |
    | GCS                            |                               ✅                              |       ✅      | Via [`hudi()`](/reference/functions/table-functions/hudi)                                                                                                                                      |
    | Azure Blob Storage             |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                  |
    | HDFS                           |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                  |
    | Local filesystem               |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                  |
    | **Access methods**             |                                                              |              |                                                                                                                                                                                                |
    | Table function                 |                               ✅                              |       ✅      | [`hudi()`](/reference/functions/table-functions/hudi)                                                                                                                                          |
    | Table engine                   |                               ✅                              |       ✅      | [`Hudi`](/reference/engines/table-engines/integrations/hudi)                                                                                                                                   |
    | Cluster-distributed reads      |                               ✅                              |       ✅      | [`hudiCluster`](/reference/functions/table-functions/hudiCluster) (S3 only)                                                                                                                    |
    | Named collections              | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |       ✅      | DDL-created [named collections](/concepts/features/configuration/server-config/named-collections) can be enabled on select ClickHouse Cloud services. Contact Support to confirm availability. |
    | **Read features**              |                                                              |              |                                                                                                                                                                                                |
    | Read support                   |                               ✅                              |       ✅      | Full `SELECT` support with all ClickHouse SQL functions                                                                                                                                        |
    | Schema evolution               |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                  |
    | Time travel                    |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                  |
    | Virtual columns                |                               ✅                              |       ✅      | `_path`, `_file`, `_size`, `_time`, `_etag`. See [Virtual columns](/reference/functions/table-functions/hudi#virtual-columns).                                                                 |
    | **Write features**             |                                                              |              |                                                                                                                                                                                                |
    | `INSERT` / `DELETE` / `UPDATE` |                               ❌                              |       ❌      | Read-only integration                                                                                                                                                                          |
    | **Caching**                    |                                                              |              |                                                                                                                                                                                                |
    | Data caching                   |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                  |
  </Tab>

  <Tab title="Apache Paimon">
    | Feature                        |                       ClickHouse Cloud                       | Self-managed | Notes                                                                                                                                                                                                                                        |
    | ------------------------------ | :----------------------------------------------------------: | :----------: | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
    | **Storage backends**           |                                                              |              |                                                                                                                                                                                                                                              |
    | S3                             | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. Via [`paimon()`](/reference/functions/table-functions/paimon) or `paimonS3()`                                                                                                                                                  |
    | GCS                            | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. Via [`paimon()`](/reference/functions/table-functions/paimon) or `paimonS3()`                                                                                                                                                  |
    | Azure Blob Storage             | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. Via [`paimonAzure()`](/reference/functions/table-functions/paimon)                                                                                                                                                             |
    | HDFS                           |                               ❌                              |      ⚠️      | Experimental and deprecated. Via [`paimonHDFS()`](/reference/functions/table-functions/paimon)                                                                                                                                               |
    | Local filesystem               |                               ❌                              |      ⚠️      | Experimental. Via [`paimonLocal()`](/reference/functions/table-functions/paimon)                                                                                                                                                             |
    | **Access methods**             |                                                              |              |                                                                                                                                                                                                                                              |
    | Table function                 | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. [`paimon()`](/reference/functions/table-functions/paimon) with variants per backend                                                                                                                                            |
    | Table engine                   | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. [`Paimon`](/reference/engines/table-engines/integrations/paimon) with variants per backend. Requires `allow_experimental_paimon_storage_engine = 1`.                                                                           |
    | Cluster-distributed reads      | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. [`paimonS3Cluster`](/reference/functions/table-functions/paimonCluster), [`paimonAzureCluster`](/reference/functions/table-functions/paimonCluster), [`paimonHDFSCluster`](/reference/functions/table-functions/paimonCluster) |
    | Named collections              | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. DDL-created [named collections](/concepts/features/configuration/server-config/named-collections) can be enabled on select ClickHouse Cloud services. Contact Support to confirm availability.                                 |
    | **Read features**              |                                                              |              |                                                                                                                                                                                                                                              |
    | Read support                   | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. Full `SELECT` support with all ClickHouse SQL functions                                                                                                                                                                        |
    | Schema evolution               |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                                                                |
    | Time travel                    |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                                                                |
    | Virtual columns                | <Tooltip tip="Contact Support for availability">⚠️</Tooltip> |      ⚠️      | Experimental. `_path`, `_file`, `_size`, `_time`, `_etag`. See [Virtual columns](/reference/functions/table-functions/paimon#virtual-columns).                                                                                               |
    | **Write features**             |                                                              |              |                                                                                                                                                                                                                                              |
    | `INSERT` / `DELETE` / `UPDATE` |                               ❌                              |       ❌      | Read-only integration                                                                                                                                                                                                                        |
    | **Caching**                    |                                                              |              |                                                                                                                                                                                                                                              |
    | Data caching                   |                               ❌                              |       ❌      | Not supported                                                                                                                                                                                                                                |
  </Tab>
</Tabs>

<h2 id="catalog-support">
  Catalog support
</h2>

ClickHouse can connect to external data catalogs using the [`DataLakeCatalog`](/reference/engines/database-engines/datalake) 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](/guides/use-cases/data-warehousing/glue-catalog)          | Iceberg        |     ✅ Beta     |       ❌      |    ❌   | [Glue catalog guide](/guides/use-cases/data-warehousing/glue-catalog)             |
| [BigLake Metastore](/guides/use-cases/data-warehousing/biglake-catalog)      | Iceberg        |     ✅ Beta     |       ❌      |    ❌   | [BigLake Metastore guide](/guides/use-cases/data-warehousing/biglake-catalog)     |
| [Databricks Unity Catalog](/guides/use-cases/data-warehousing/unity-catalog) | Delta, Iceberg |     ✅ Beta     |    ✅ Beta    | ✅ Beta | [Unity Catalog guide](/guides/use-cases/data-warehousing/unity-catalog)           |
| [Iceberg REST](/guides/use-cases/data-warehousing/rest-catalog)              | Iceberg        |     ✅ Beta     |       ❌      |    ❌   | [REST catalog guide](/guides/use-cases/data-warehousing/rest-catalog)             |
| [Lakekeeper](/guides/use-cases/data-warehousing/lakekeeper-catalog)          | Iceberg        |     ✅ Beta     |       ❌      |    ❌   | [Lakekeeper catalog guide](/guides/use-cases/data-warehousing/lakekeeper-catalog) |
| [Project Nessie](/guides/use-cases/data-warehousing/nessie-catalog)          | Iceberg        | ✅ Experimental |       ❌      |    ❌   | [Nessie catalog guide](/guides/use-cases/data-warehousing/nessie-catalog)         |
| [Microsoft OneLake](/guides/use-cases/data-warehousing/onelake-catalog)      | Iceberg        |     ✅ Beta     |    ✅ Beta    | ✅ Beta | [OneLake catalog guide](/guides/use-cases/data-warehousing/onelake-catalog)       |
| [SeaweedFS](/guides/use-cases/data-warehousing/seaweedfs-catalog)            | Iceberg        |     ✅ Beta     |    ✅ Beta    | ✅ Beta | [SeaweedFS catalog guide](/guides/use-cases/data-warehousing/seaweedfs-catalog)   |

All catalog integrations currently require an experimental or beta setting to be enabled. With the exception of Microsoft OneLake, Databricks Unity Catalog, and SeaweedFS, all catalogs 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](/guides/use-cases/data-warehousing/getting-started/accelerating-analytics). To write data back to open table formats, create standalone Iceberg tables as described in the [writing data guide](/guides/use-cases/data-warehousing/getting-started/writing-data).