ClickHouse

Read and write ClickHouse over its HTTP interface: columnar all the way, with no driver to install.

Category: Warehouse
Used by: 2 nodes

Settings

What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.

Host
Port	8123 for HTTP, 8443 for HTTPS and ClickHouse Cloud. Leave blank to default by protocol.
Protocol	Choices: http; https.
Database	Optional default database for unqualified table names. Blank uses 'default'.
Username	Blank uses 'default', ClickHouse's own default user.
Password	Leave blank for a server whose user has no password. Stored encrypted, and never shown again after you save it.

Testing the connection

Test runs SELECT 1 over ClickHouse's HTTP interface.

Good to know

Data travels columnar in both directions, with no driver to install.
A blank database means ClickHouse's default database.

Nodes that use it

ClickHouse input

Read a table or SQL query from ClickHouse. Columns show without a run, even for a query you write yourself. A Bookmark can read only the rows added or changed since the last successful run.

ClickHouse output

Load rows into a ClickHouse table (append or replace; auto-creates a MergeTree).