Skip to main content


Grafana is a monitoring dashboard system, which is an open-source monitoring tool developed by Grafana Labs. It can greatly simplify the complexity of monitoring by allowing us to provide the data to be monitored, and it generates various visualizations. Additionally, it has an alarm function that sends notifications when there is an issue with the system.

The following tutorial will guide you on how to integrate Databend Cloud with Grafana and display the data imported from the Analyzing Anonymous Click Dataset tutorial on a Grafana dashboard.

Tutorial: Integrate with Grafana


Step 1: Install Altinity plugin for ClickHouse

  1. Click on the gear icon in the sidebar on the Grafana homepage, and then select Plugins.

  2. On the Plugins tab, search for and install the Altinity plugin for ClickHouse.

Step 2: Create a data source

  1. Click on the gear icon in the sidebar on the Grafana homepage, and then select Data sources.

  2. On the Data sources tab, select Add new data source.

  3. Search for and select the data source type Altinity plugin for ClickHouse.

  4. Configure the data source. To obtain the connection information of Databend Cloud, see Connecting to a Warehouse.

    URLThe host address of the warehouse in Databend Cloud should be provided in the following format: Please note that the address must start with "https://".
    AccessSelect Server (default).
    AuthSelect Basic auth.
    User/PasswordAfter selecting Basic auth, enter the SQL username and password used to connect to the warehouse in the Basic Auth Details.
    AdditonalSelect Add CORS flag to requests.
  5. Click Save & test. If the page displays "Data source is working", it indicates that the data source has been successfully created.

Step 3: Create a dashboard

  1. On the sidebar of the Grafana homepage, click the Dashboards button, then select New Dashboard > New Panel.

  2. Select the data source created in Step 2, and then select the default database and hits_100m_obfuscated_v1 table in order after FROM.

Alt text

  1. Click Go to Query, and then copy and paste the following SQL statement:
eventtime as t,
FROM $table
  1. Wait for a moment and the view should appear at the top of the page. Then click Save in the upper right corner.

Alt text

Did this page help you?