๐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 9000User
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 databasesTable
, 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 aselect * 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