connector
ClickHouse logo

ClickHouse

Column-oriented database built for fast analytical queries.

Connection fields

FieldRequiredDescription
hostYesHostname or IP address of the ClickHouse server.
portNoHTTP interface port. Defaults to 8123 — not the native TCP protocol's 9000.
userNoUsername, if the server requires auth.
passwordNoPassword for user.
dbYesDatabase name to connect to.
use_httpsNoUse 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
}