connector
ClickHouse
Column-oriented database built for fast analytical queries.
Connection fields
| Field | Required | Description |
|---|---|---|
host | Yes | Hostname or IP address of the ClickHouse server. |
port | No | HTTP interface port. Defaults to 8123 — not the native TCP protocol's 9000. |
user | No | Username, if the server requires auth. |
password | No | Password for user. |
db | Yes | Database name to connect to. |
use_https | No | Use HTTPS for the HTTP interface. Defaults to false. |
This connector talks to ClickHouse's HTTP interface, not the native TCP protocol — make sure the configured port is the HTTP one (8123 by default, or ClickHouse Cloud's HTTPS port).
Example configuration
{
"host": "clickhouse.internal.example.com",
"port": 8123,
"user": "arcodash_reader",
"password": "••••••••",
"db": "analytics",
"use_https": false
}