Visualize ClickHouse® data with Grafana®
You can visualise your ClickHouse® data using Grafana® and Aiven can help you connect the two services.
Prerequisites
- Aiven for ClickHouse® service accessible by HTTPS
- 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).
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. |
Integrate ClickHouse® with Grafana®
- Log in to Aiven for Grafana® following the instructions.
- From the Configuration menu, select Data sources > Add data source.
- Find Altinity plugin for ClickHouse in the list and select it.
- Set URL to
CLICKHOUSE_HTTPS_URI
. - In Auth section, enable Basic auth and With Credentials.
- In Basic Auth Details, set your
CLICKHOUSE_USER
andCLICKHOUSE_PASSWORD
. - Select Save & test.
Now you can create a dashboard and panels to work with the data from your Aiven for ClickHouse® service.