ClickHouse

Updated on May 12, 2025

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.

Setup guide

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:

Enter a name for your Destination connection in the Title.
Enter the Host.
Enter the Port.
Enter the User Name.

Enter the Password.
Enter the Database Name.

Select the necessary Interface option from the dropdown.
Select the necessary Use static IP option from the dropdown.

Select the necessary Use binary strings option from the dropdown.

‍

Was this article helpful?