Documentation

Note: ClickHouse is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for ClickHouse.

Description

‍ClickHouse is an open-source column-oriented database management system designed for real-time analytical processing of big data.

Follow our setup guide to connect ClickHouse to Improvado.

Permissions

You should have write access to the database and the following permissions:

• ```SELECT```
• ```CREATE TABLE```
• ```CREATE TEMPORARY TABLE```
• ```S3```
• ```INSERT```
• ```ALTER COLUMN```
• ```ALTER DELETE```
• ```TRUNCATE```
• ```DROP TABLE```

Complete configuration

On the ClickHouse connection page, fill in the following fields:

1. Enter a name for your Destination connection in the Title.
2. Enter the Host.
3. Enter the Port.
4. Enter the User Name. {%dropdown-button name="user-name"%}

{%dropdown-body name="user-name"%}

The maximum length is 63 characters.

{%dropdown-end%}

5. Enter the Password.
6. Enter the Database Name. {%dropdown-button name="database-name"%}

{%dropdown-body name="database-name"%}

Database Name can only contain letters, numbers and underscores. It must start with a letter and cannot end with an underscore.

The maximum length is 63 characters.

{%dropdown-end%}

7. Select the necessary Interface option from the dropdown.
8. Select the necessary Use static IP option from the dropdown. {%dropdown-button name="use-static-ip"%}

{%dropdown-body name="use-static-ip"%}

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

{%dropdown-end%}