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

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

HTTP Protocol Example

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

Reference