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
Before you start, please refer to the official installation guide of Grafana to install Grafana: https://grafana.com/docs/grafana/latest/setup-grafana/installation
Complete the Analyzing Anonymous Click Dataset tutorial first and ensure that the dataset has been successfully imported into the
hits_100m_obfuscated_v1table in the
Step 1: Install Altinity plugin for ClickHouse
Click on the gear icon in the sidebar on the Grafana homepage, and then select Plugins.
On the Plugins tab, search for and install the
Altinity plugin for ClickHouse.
Step 2: Create a data source
Click on the gear icon in the sidebar on the Grafana homepage, and then select Data sources.
On the Data sources tab, select Add new data source.
Search for and select the data source type Altinity plugin for ClickHouse.
Configure the data source. To obtain the connection information of Databend Cloud, see Connecting to a Warehouse.
Settings Description URL The host address of the warehouse in Databend Cloud should be provided in the following format: https://tnf34b0rm--small-book.ch.aliyun-cn-beijing.default.databend.com. Please note that the address must start with "https://". Access Select Server (default). Auth Select Basic auth. User/Password After selecting Basic auth, enter the SQL username and password used to connect to the warehouse in the Basic Auth Details. Additonal Select Add CORS flag to requests.
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
On the sidebar of the Grafana homepage, click the Dashboards button, then select New Dashboard > New Panel.
Select the data source created in Step 2, and then select the
hits_100m_obfuscated_v1table in order after FROM.
- Click Go to Query, and then copy and paste the following SQL statement:
eventtime as t,
GROUP BY t
ORDER BY t
- Wait for a moment and the view should appear at the top of the page. Then click Save in the upper right corner.