Skip to main content

ClickHouse

Choosing a Configuration Type​

To specify the configuration type, you need to select one of the tiles displayed on the page. In this case, select the Clickhouse tile.

Important!

Once saved, the configuration type cannot be changed.

Entering Connection Information​

Further configuration details are entered in the "Enter configuration information" section. Fields marked with a red asterisk are mandatory. If any field contains incorrect data, the configuration will not be saved, and an error message will appear next to the field with the issue. Follow these steps to input connection information:

  1. Enter the configuration name in the "Configuration Name" input field. Only Latin letters or numbers in CamelCase style are allowed.
  2. Then, select a JDBC driver in the "Upload Driver" field. If the required driver is not listed, you can upload your own by clicking the "Upload File" button below the input field. A modal window will open where you need to select a JDBC driver with a .jar extension. Other file types will not be accepted.
  3. The "Driver Class Name" field is filled automatically. If the JDBC driver contains multiple classes, you can specify the required class. Only Latin letters or numbers are allowed in this field.
Note!

By default, the connection string field is auto-populated based on the JDBC driver class. For ClickHouse, the following classes are supported: cc.blynk.clickhouse.ClickHouseDriver, com.clickhouse.jdbc.ClickHouseDriver. If the driver uses different classes, the connection string will still be auto-filled, but you should verify the "Connection String" field for accuracy. Otherwise, switch to advanced mode and correct it manually.

  1. Enter the host in the "Host" field. Examples include http://172.168.0.1 or https://yourhost.
  2. Enter the port in the "Port" field. Only numbers are allowed.
  3. If needed, you can specify the default database name in the "Default Database" field.
  4. If your connection requires SSL validation, enable the "SSL Validation" field. A warning about saving data in the keystore will appear, as shown in the illustration.

ClickHouse Keystore Warning

You can then enable host name verification and specify the path to the trust store in the "Trust Store Path" field. Only paths like /my_path/to/trust-store/ are allowed.

Important!

SSL parameters are set for the official ClickHouse driver. If you use a different driver, switch to advanced mode and enter the required parameters manually.

  1. If your connection requires user and password authentication or just a username, fill in the respective "User" and "Password" fields.

  2. To test the connection, click the "Test Connection" button. If the ClickHouse connection is successful, the following message will appear:

Successful Connection

Otherwise, an error message will be displayed, such as:

Connection Error

Note

The article shows an example error message. The actual error may vary.

The configuration can be saved with connection errors. However, it will not be saved if there are format errors or empty mandatory fields.

Editing Configuration Features​

The configuration can be edited according to the same rules as when it is created. Fields can be edited in any order to customize the configuration as needed.