ClickHouse

ClickHouse

  • Purpose: Connect to ClickHouse, a high-performance column-oriented database for OLAP analytics.
  • When to use it: Best for real-time analytics on large event datasets where query speed is critical.
  • How to create it:
    1. Go to Data Sources and click Add.
    2. Select ClickHouse.
    3. Name: Enter a unique name for this connection.
    4. Host: ClickHouse server IP or hostname.
    5. Port: Default is 8123 (HTTP interface).
    6. Database Name: The ClickHouse database to connect to.
    7. Username / Password: Your ClickHouse credentials (default user is default).
    8. SSH Tunnel: (Optional) Enable for private servers — see SSH Tunnel.
    9. Click Test Connection to verify, then Save.

ClickHouse Configuration