🔌Setting up a Clickhouse Connector

Clickhouse connector¶

This connector can be used to connect to a Clickhouse Database. clickhouse documentation

How to connect ?¶

This connector is quite straight-forward to configure.

Data provider configuration

Only few fields need to be filled in the Data Provider configuration:

• Name

• Host it could be an IP address or an hostname (e.g localhost)

• Port an integer, by default clickhouse runs on port 9000

• User

• Password

• ssl_connection a checkbox to enable SSL wrapped TCP connection

clickhouse1

Data Source configuration

The Clickhouse Data Source configuration form is like the other SQL data source, available fields are:

• Database, a dropdown list of available databases

• Table, a drop down list of available tables. The list will be populated only when a database is selected.

• Query, a string field where you can write your SQL query, if left blank a select * from Table limit 50 will run

The configurations below will help you to fill the form:

clickhouse2

clickhouse3

And that’s all, your Clickhouse Connector is ready to be used ! 🚀