ClickHouse
Connect Erathos to Clickhouse.
ClickHouse
You can connect the Erathos platform to your ClickHouse instance 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 Setup
Connection Credentials
The easiest way to find your credentials is via your database configuration or the ClickHouse Cloud console. If you are using ClickHouse Cloud:
Log into your ClickHouse Cloud console and select your service.
Click the Connect button on your service overview page. This will open a panel containing your integration details.
Locate your Host (your service URL, which usually ends in
.clickhouse.cloud).
Locate your Port (typically 8443 for HTTPS).
Identify your Username (the default is usually
default).Retrieve your Password, which was generated when you initially created the service.
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.
Connect to Erathos
To connect Erathos to your ClickHouse database:
Create a New Destination: Go to Settings > Destination and select ClickHouse.
Input db_host: Paste the Host URL copied from your connection panel.
Input db_port: Enter your designated port (e.g., 8443).
Input db_username: Enter your database username.
Input db_password: Enter your database password.
Complete the Setup: Save the configuration to finalize the connection.
If you need help connecting to your ClickHouse database, reach out to our team at support@erathos.com.
Last updated