Skip to content

Clickhouse

ClickHouse connector allows querying ClickHouse databases.

Config Schema

FieldTypeRequiredDescription
typestringyesconstant: clickhouse
hoststringnoSingle host address
hostsstring[]noMultiple hosts for cluster setup
databasestringyesDatabase name
userstringyesUsername
passwordstringyesPassword
portintegeryesHTTP port (default 8123)
securebooleannoUse HTTPS instead of HTTP
conn_stringstringnoDirect connection string

Config example:

type: clickhouse
host: localhost # Single host address
hosts: # Or multiple hosts for cluster setup
- host1.example.com
- host2.example.com
database: mydb
user: default
password: secret
port: 8123
secure: false # Use HTTPS instead of HTTP

Or as alternative with direct connection string:

type: clickhouse
conn_string: http://default:secret@localhost:8123/mydb