ClickHouse

About

ClickHouse is a fast, open-source, column-oriented database

Available Tools

• clickhouse-execute-sql
  Execute parameterized SQL queries in ClickHouse with query logging.

• clickhouse-sql
  Execute SQL queries as prepared statements in ClickHouse.

Requirements

Database User

This source uses standard ClickHouse authentication. You will need to create a ClickHouse user (or with ClickHouse Cloud) to connect to the database with. The user should have appropriate permissions for the operations you plan to perform.

Network Access

ClickHouse supports multiple protocols:

• HTTPS protocol (default port 8443) - Secure HTTP access (default)
• HTTP protocol (default port 8123) - Good for web-based access

Example

Secure Connection Example

kind: sources
name: secure-clickhouse-source
type: clickhouse
host: clickhouse.example.com
port: "8443"
database: analytics
user: ${CLICKHOUSE_USER}
password: ${CLICKHOUSE_PASSWORD}
protocol: https
secure: true

HTTP Protocol Example

kind: sources
name: http-clickhouse-source
type: clickhouse
host: localhost
port: "8123"
database: logs
user: ${CLICKHOUSE_USER}
password: ${CLICKHOUSE_PASSWORD}
protocol: http
secure: false

Reference