Version: 1.0.0
Category: Database
Tier: 3
Type: Source, Target
Authentication:
Standard Authentication:
Host
Port
Database Name
Username
Password
Supported Save Mode as Target:
Append
Overwrite
See: Target Connector Save Modes
Connection Properties:
...
Name | Mandotory | Description |
|---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of the connection |
Username | Yes | Username of the database |
Password | Yes | Password of the database |
Host | Yes | Host or “Endpoint“ |
Port | Yes | Port number |
Database Name | Yes | Name of the database |
ClickHouse connector User Guide
Log in to your clickhouse account
Click on the Development button. It will should Your Service -name
Connect to your sql client from the connection tab
...
c. Here you can create tables and query data. Click on new Table button on left to create table.
...
In this example, we already have 3 tables. ‘clickcustomers’, ‘clicktrips’, and ‘my_data’. We will use them in the EazyDi app Clickhouse connector test.
To Connect your Database to EazyDi app, you will need:
Host
Port
Username
Database name
Password
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.
...
Once you have all your credentials, you can now connect your database to EazyDi app. Create a connection. Select the Clickhouse -
...
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.
Once you have created a connection, you can now select a table from the list of connection objects
...
Steps to create connection:
There are two ways to create connection -
Choose the Clickhouse connector from Pipeline tab > add connection.
...
b. Go to the Connections tab > add connection > from the dropdown select Clickhouse.
...
Fill in the required details.
Click on the Test connection button to confirm.
Click Create connection.