This article guides you through the process of connecting Clickhouse to Peaka, allowing you to seamlessly access your Clickhouse data within the Peaka platform.

Prerequisites

Before you start, you will need the following information from Clickhouse.

  • URL
  • PORT
  • User Name
  • Password
  • SSL (Toggle “Connect Through TLS” switch)

Follow the steps below to obtain it:

  1. Open the Clickhouse dashboard.

  2. Click on the “Connect” button as shown in the image below.

  1. It will open a modal and show the connection detail such as URL, PORT, User Name, and Password.

Connecting Clickhouse to Peaka

Now that you have obtained the necessary integration data and credentials, you can connect Clickhouse to Peaka using the following steps:

  1. Navigate to the data model page in Peaka.

  2. Click the “Add First Connection” button to initiate the connection process:

  3. In the modal that appears, select “Clickhouse” as your connection type.

  4. Enter a name for your connection, input the credentials you obtained in the previous steps, and toggle the “Connect Through TLS” switch if SSL is required.

  1. Click “Next” to create your Clickhouse connection.

Congratulations! You’ve successfully connected Clickhouse to Peaka. You can now access and manage your Clickhouse data seamlessly within the Peaka platform.