Purpose

ClickHouse through its HTTP interface (port 8123, HTTPS 8443). Writing only appends rows.

Connection fields

FieldRule and default valueExplanation
HTTP interface address
url
RequiredSet the value according to your service configuration.
Database
database
Required
Default: default
Set the value according to your service configuration.
User
username
Required
Default: default
Set the value according to your service configuration.
Password
secret
Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →