> For the complete documentation index, see [llms.txt](https://docs.erathos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.erathos.com/destinations/what-is-a-destination/clickhouse.md).

# ClickHouse

You can connect the Erathos platform to any ClickHouse instance, including **ClickHouse Cloud** and **self-hosted deployments**, to leverage its high-performance, column-oriented database capabilities.

To connect to your ClickHouse instance, the following information is necessary: Host, Port, Username, and Password.

The tutorial below shows you how to obtain these credentials.

### ClickHouse Cloud

The easiest way to find your credentials is via your database configuration or the ClickHouse Cloud console. If you are using ClickHouse Cloud:

1. Log into your ClickHouse Cloud console and select your service.
2. Click the Connect button on your service overview page. This will open a panel containing your integration details.

   <figure><img src="/files/tRf5KGgJu7pJOELRFork" alt=""><figcaption></figcaption></figure>
3. Locate your Host (your service URL, which usually ends in `.clickhouse.cloud`).

   <figure><img src="/files/DHVmF5rvqUIHTetmPBM9" alt=""><figcaption></figcaption></figure>
4. Locate your Port (typically 8443 for HTTPS).
5. Identify your Username (the default is usually `default`).
6. Retrieve your Password, which was generated when you initially created the service.

{% hint style="info" %}
For security reasons, ClickHouse Cloud only displays the password once upon service creation. If you do not have it saved, you must go to your service settings to reset the password. Confirm you have copied and pasted the new password somewhere safe before proceeding.
{% endhint %}

### Self-Hosted ClickHouse

If you are using a self-hosted ClickHouse deployment (VM, Kubernetes, Docker or any other environment), obtain the following information from your server configuration or your database administrator:

* **Host**: The hostname or IP address of your ClickHouse server.
* **Port**: The port exposed by your ClickHouse server (commonly `8123` for HTTP or `8443` for HTTPS, depending on your configuration).
* **Username**: A ClickHouse user with the required permissions.
* **Password**: The password associated with that user.

Make sure your ClickHouse instance is reachable from the Erathos platform and that any required firewall or network rules allow the connection.

{% hint style="info" %}
Include our IP address (**35.212.87.86**) to your firewall’s whitelist.
{% endhint %}

### Connect to Erathos

To connect Erathos to your ClickHouse database:

1. Create a New Destination: Go to Settings > Destination and select ClickHouse.
2. Input db\_host: Paste the Host URL copied from your connection panel.
3. Input db\_port: Enter your designated port (e.g., 8443).
4. Input db\_username: Enter your database username.
5. Input db\_password: Enter your database password.
6. Complete the Setup: Save the configuration to finalize the connection.

{% hint style="info" %}
If you need help connecting to your ClickHouse database, reach out to our team at [support@erathos.com](https://www.google.com/search?q=mailto%3Asupport%40erathos.com).
{% endhint %}