Integrating Confluent Cloud with ClickHouse

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/integrations/data-ingestion/kafka/confluent/confluent-cloud.md)

## Prerequisites[​](#prerequisites "Direct link to Prerequisites")

We assume you're familiar with:

- [ClickHouse Connector Sink](/docs/integrations/kafka/clickhouse-kafka-connect-sink)
- Confluent Cloud

## The official Kafka connector from ClickHouse with Confluent Cloud[​](#the-official-kafka-connector-from-clickhouse-with-confluent-cloud "Direct link to The official Kafka connector from ClickHouse with Confluent Cloud")

#### Create a Topic[​](#create-a-topic "Direct link to Create a Topic")

Creating a topic on Confluent Cloud is fairly simple, and there are detailed instructions [here](https://docs.confluent.io/cloud/current/client-apps/topics/manage.html).

#### Important notes[​](#important-notes "Direct link to Important notes")

- The Kafka topic name must be the same as the ClickHouse table name. The way to tweak this is by using a transformer (for example [`ExtractTopic`](https://docs.confluent.io/platform/current/connect/transforms/extracttopic.html)).
- More partitions doesn't always mean more performance - see our upcoming guide for more details and performance tips.

#### Gather your connection details[​](#gather-your-connection-details "Direct link to Gather your connection details")

To connect to ClickHouse with HTTP(S) you need this information:

|  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Parameter(s) Description|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | `HOST` and `PORT` Typically, the port is 8443 when using TLS or 8123 when not using TLS.|  |  |  |  | | --- | --- | --- | --- | | `DATABASE NAME` Out of the box, there is a database named `default`, use the name of the database that you want to connect to.| `USERNAME` and `PASSWORD` Out of the box, the username is `default`. Use the username appropriate for your use case. | | | | | | | |

The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console.
Select a service and click **Connect**:

Choose **HTTPS**. Connection details are displayed in an example `curl` command.

If you're using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.

#### Install Connector[​](#install-connector "Direct link to Install Connector")

Install the fully managed ClickHouse Sink Connector on Confluent Cloud following the [official documentation](https://docs.confluent.io/cloud/current/connectors/cc-clickhouse-sink-connector/cc-clickhouse-sink.html).

#### Configure the Connector[​](#configure-the-connector "Direct link to Configure the Connector")

During the configuration of the ClickHouse Sink Connector, you will need to provide the following details:

- hostname of your ClickHouse server
- port of your ClickHouse server (default is 8443)
- username and password for your ClickHouse server
- database name in ClickHouse where the data will be written
- topic name in Kafka that will be used to write data to ClickHouse

The Confluent Cloud UI supports advanced configuration options to adjust poll intervals, batch sizes, and other parameters to optimize performance.

Note

On Confluent Cloud, adjustment of certain settings such as [fetch settings](/docs/integrations/kafka/clickhouse-kafka-connect-sink#fetch-settings) and [poll settings](/docs/integrations/kafka/clickhouse-kafka-connect-sink#poll-settings) requires opening a support case through Confluent Cloud.

#### Known limitations[​](#known-limitations "Direct link to Known limitations")

- See the list of [Connectors limitations in the official docs](https://docs.confluent.io/cloud/current/connectors/cc-clickhouse-sink-connector/cc-clickhouse-sink.html#limitations)

- [Prerequisites](#prerequisites)- [The official Kafka connector from ClickHouse with Confluent Cloud](#the-official-kafka-connector-from-clickhouse-with-confluent-cloud)

Was this page helpful?