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.

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.

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.

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`