๐Ÿ”Œ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

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:

And thatโ€™s all, your Clickhouse Connector is ready to be used ! ๐Ÿš€

Last updated