🔌Add a ClickHouse connector

This data connector is supported by our new Data Execution system!

Configuring a ClickHouse connection¶

Fill the connection parameters

Field	Format / Type	Description	Example
Name (mandatory)	String	Use it to identify your connection	my_clickhouse_connector
Host (mandatory)	String	could be an IP address or an hostname (e.g localhost)	"db.example.com" or "192.168.1.100"
Port (mandatory)	Integer	an integer, by default ClickHouse runs on port 9000	9000 (default)
User (mandatory)	String	Your login user	db_user
Password (mandatory)	String	Your login password (this value will be stored as a secret)	abcD1234
SSL_connection (optional)	Boolean	Allow to enable to enable SSL wrapped TCP connection
Retry Policy (optional)	Boolean	Boolean allows to configure a retry policy if the connection is flaky. max attempts: maximum number of retries before giving up max_delay: in seconds, above the connection is dropped wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)	Integer	Slow queries' cache expiration time in seconds

Click on the TEST CONNECTION button then SAVE the connection

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Create a dataset from a ClickHouse connection

This data connector is only supported in code/SQL mode

Fill the mandatory fields:

• 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