Connecting ClickHouse to Hashboard

​

Pre-requisites

• A ClickHouse database either hosted on your own infrastructure or on ClickHouse Cloud.
• A Hashboard account and project.

​

Steps to connect Hashboard to ClickHouse

1

Gather your connection details

To connect to ClickHouse with native TCP you need this information:

Parameters	Description
HOST and PORT	Typically, the port is 9440 when using TLS, or 9000 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 the service that you will connect to and click Connect:

Choose Native, and the details are available in an example clickhouse-client command.

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

2

Add a new database connection in Hashboard

1. Navigate to your Hashboard project.
2. Open the Settings page by clicking the gear icon in the side navigation bar.
3. Click + New Database Connection.
4. In the modal, select “ClickHouse.”
5. Fill in the Connection Name, Host, Port, Username, Password, and Database fields with the information gathered earlier.
6. Click “Test” to validate that the connection is configured successfully.
7. Click “Add”

Your ClickHouse database is now be connected to Hashboard and you can proceed by building Data Models, Explorations, Metrics, and Dashboards. See the corresponding Hashboard documentation for more detail on these features.

​

Learn more