Connecting Clickhouse as destination using Bold Data Hub

Published:

Introduction

This guide will walk you through the steps to connect Clickhouse as an destination using Bold Data Hub.

Prerequisites

Credentials: Ensure that the Clickhouse credentials are correct and have the necessary permissions.

Steps

Step 1: Open Bold Data Hub

Launch the Bold Data Hub application.

Step 2: Set up the Clickhouse Credentials

Navigate to the Settings section in Bold Data Hub.
Click on the settings icon.

Step 3: Select Connection Type

Choose the connection type as New.

Step 4: Configure Clickhouse

Select the server type as Clickhouse.
Fill in your Clickhouse credentials as follows:
- Datastore Name: Enter a meaningful name; this is how the Clickhouse credentials will be stored in Bold Data Hub.
- Server: Enter the server name.
  Example: service.region.clickhouse.cloud or private ip
Secure Connection: Enter your connection type as Insecure (HTTP) or Secure (HTTPS)
Http Port number: Enter your Http and Tcp port number.
Username: Enter your Clickhouse username.
Password: Input your Clickhouse password.
Database: Enter your Clickhouse database name.

Step 5: Save the Credentials

Click Save to store the credentials.

Step 6: Add Pipeline

Click on Add Pipeline, give the pipeline a meaningful name, and click the tick icon or press Enter.

Note: In Bold BI, the data source will be created under the given pipeline name.

Step 7: Add Template Details

Click the pipeline and then choose the connector from which you want to extract data.
Click the add template button and add the details in the template.

Step 8: Save Template Details

Click the Save button. Choose the data store name from the dropdown and click Yes. Once saved, validation will be completed, and the pipeline will start.