Skip to content

ClickHouse

ClickHouse

It is mainly used to describe how the software builds the ClickHouse data source for subsequent operations.

System requirements

>= 1.0.0-SNAPSHOT

Supported Versions


Version Tested?
19.10.x
20.11.x
21.3.x
22.12.x

Supported versions

Most versions have been tested, please submit issues for non-adapted versions.

Created a Source


After entering the data source management page, click the Add data source button.

img.png

Select the ClickHouse icon in the Basic type (the first one).

After selecting the type, click the Next button at the bottom to configure the relevant information.

img_1.png

Supported protocols

  • HTTP
  • SSH

HTTP Protocol


HTTP Protocol

Use the HTTP interface provided by ClickHouse to connect to the service.

Parameter Description Required Unique Default
Alias The alias of the data source, which will be displayed later in the selected data source on the page Yes Yes
Host The host of the ClickHouse server Yes Yes
Port The port of the ClickHouse server Yes Yes 8123
User Name The user name of the ClickHouse server Yes No
Password The password of the ClickHouse server Yes No

When we have configured the above parameters, click the Test button at the bottom. If the service can be accessed normally, the OK button can be used. Click it and it will be saved.

SSH Protocol


SSH Protocol

The SSH protocol will remotely access the target ClickHouse service through the springboard machine (configured SSH server).

The SSH protocol first needs to fill in the relevant configuration information in the HTTP protocol.

img.png

SSH Configuration

The difference is that the SSH protocol has the following configurations.

Parameter Description Required Unique Default
SSH Host The host of the SSH server Yes Yes
SSH Port The port of the SSH server Yes Yes 22
User Name The user name of the SSH server Yes Yes root
Password The password of the SSH server Yes Yes 123456

When we have configured the above parameters, click the Test button at the bottom. If the service can be accessed normally, the OK button can be used. Click it and it will be saved.

Comments

Back to top