ClickHouse

Load event data into ClickHouse for real-time analytics and high-performance columnar storage.

Configuration

Field	Type	Required	Description
`host`	string	Yes	The ClickHouse server hostname.
`port`	string	Yes	The ClickHouse HTTP(S) port. Defaults to `8443`.
`database`	string	Yes	The target database name.
`table`	string	Yes	The target table name to insert rows into.
`username`	string	Yes	The ClickHouse username for authentication.
`password`	secret	Yes	The ClickHouse password for authentication.
`use_tls`	boolean	No	Enable TLS for the connection. Defaults to `true`.

Quick Setup

Navigate to Integrations in the sidebar.
Open the Integration Library tab.
Find ClickHouse or filter by Cloud Storage.
Click Install, select a variant if available, and fill in the required fields.
Click Install Integration to create the integration with a ready-to-use default configuration.

API Setup

curl -X POST http://localhost:8084/v1/admin/integration-catalog/clickhouse/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "ClickHouse",
    "variant": "default",
    "config": {
      "host": "clickhouse.example.com",
      "port": "8443",
      "database": "analytics",
      "table": "events",
      "username": "datafly",
      "use_tls": true
    },
    "delivery_mode": "server_side"
  }'

Delivery

Events are delivered server-side from your Datafly Signal infrastructure directly to ClickHouse. No client-side scripts are loaded for this integration.

Visit ClickHouse documentation for full API documentation and credential setup instructions.

Azure Synapse Confluent Cloud