Skip to main content

Visualize ClickHouse® data with Grafana®

You can visualise your ClickHouse® data using Grafana® and Aiven can help you connect the two services.

Prerequisites

  1. Aiven for ClickHouse® service accessible by HTTPS
  2. Aiven for Grafana® service (see how to get started with Aiven for Grafana®)

Variables

You'll need a few variables for the setup. To get their values, go to Aiven Console and go to Overview of your Aiven for ClickHouse® service (Connection information > ClickHouse HTTPS & JDBC).

VariableDescription
CLICKHOUSE_HTTPS_URIHTTPS service URI of your ClickHouse service.
CLICKHOUSE_USERUsername to access ClickHouse service.
CLICKHOUSE_PASSWORDPassword to access ClickHouse service.

Integrate ClickHouse® with Grafana®

  1. Log in to Aiven for Grafana® following the instructions.
  2. From the Configuration menu, select Data sources > Add data source.
  3. Find Altinity plugin for ClickHouse in the list and select it.
  4. Set URL to CLICKHOUSE_HTTPS_URI.
  5. In Auth section, enable Basic auth and With Credentials.
  6. In Basic Auth Details, set your CLICKHOUSE_USER and CLICKHOUSE_PASSWORD.
  7. Select Save & test.

Now you can create a dashboard and panels to work with the data from your Aiven for ClickHouse® service.