Visualize ClickHouse® data with Grafana®#

You can visualise your ClickHouse data with the help of Grafana. Aiven can help you connect these services services.

Prerequisites#

You will need:

  1. Aiven for ClickHouse service, accessible by HTTPS

  2. Aiven for Grafana service, see how to get started with Aiven for Grafana

Variables#

We’ll use these values later in the set up. They can be found in your Aiven for ClickHouse service page, in connection information for HTTPS endpoint.

Variable

Description

CLICKHOUSE_HTTPS_URI

HTTPS service URI of your ClickHouse service.

CLICKHOUSE_USER

Username to access ClickHouse service.

CLICKHOUSE_PASSWORD

Password to access ClickHouse service.

Integration steps#

  1. Follow these instructions to log in into Aiven for Grafana.

  2. In Configuration menu select Data sources.

  3. Click to Add data source.

  4. Find Altinity plugin for ClickHouse in the list and select it. You’ll see a panel with list of settings to fill in.

  5. Set URL to CLICKHOUSE_HTTPS_URI.

  6. In Auth section enable Basic auth and With Credentials.

  7. In Basic Auth Details set your CLICKHOUSE_USER and CLICKHOUSE_PASSWORD.

  8. Press on Save & test.

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