Articles in this section

Set up a connection to ClickHouse

ClickHouse is an open-source columnar database management system (DBMS) built for online analytical processing (OLAP). It is designed to process large volumes of data and execute analytical queries with high performance and low latency.

Set up a connection

After you start the connection, configure it in the Create connection panel and complete all of the required * authentication settings:

Setting

Instructions

Name your connection * 

Enter a clear and distinguishable name.

Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.

Organization ID *

Enter your ClickHouse organization ID. For more information on retrieving the organization ID, see API reference.

Key ID *

Enter your ClickHouse account key ID (username).

Key secret *

Enter your ClickHouse account key secret (password).

Tip

This connector documentation describes only the settings shown for the Simple view. For the corresponding HTTP settings, see OAuth 2.0 auth universal connector documentation.