Connecting ClickHouse to Hashboard

Hashboard is a robust analytics platform that can be easily integrated with ClickHouse for real-time data analysis.

Hashboard is an interactive data exploration tool that enables anyone in your organization to track metrics and discover actionable insights. Hashboard issues live SQL queries to your ClickHouse database and is particularly useful for self-serve, ad hoc data exploration use cases.

This guide will walk you through the steps to connect Hashboard with your ClickHouse instance. This information is also available on Hashboard’s ClickHouse integration documentation.

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

For more advanced features and troubleshooting, visit Hashboard’s documentation.