ClickHouse connector User Guide

Owned by Neha Awalwar
Jun 27, 2024
2 min read

  1. Log in to your clickhouse account 

    1. Click on the Development button. It will should Your Service -name  

    2. Connect to your sql client from the connection tab.

image-20240422-085048.png

c. Here you can create tables and query data. Click on new Table button on left to create table.

image-20240422-085412.png

In this example, we already have 3 tables. ‘clickcustomers’, ‘clicktrips’, and ‘my_data’. We will use them in the EazyDi app Clickhouse connector test.

 

  1. To Connect your Database to EazyDi app, you will need:

  • Host

  • Port

  • Username

  • Database name

  • Password

  1. In the EazyDi app, create a connection using the connection string provided. By default, the username and database name is set to “default”. The port is “8443” and the host depends on the cloud provider you used. In this case we used Google Cloud.

  1. Once you have all your credentials, you can now connect your database to EazyDi app. Create a connection. Select the Clickhouse -

  1. Input all the required connection properties that you got from Step 3.

Note - You can give any connection name in order to create connection in EazyDi.

  1. Once you have created a connection, you can now select a table from the list of connection objects.