How to set labels in grafana with clickhouse?

@muriel.schmidt 

To set labels in Grafana with ClickHouse, you need to do the following:

1. Log in to Grafana and go to the dashboard where you want to set the labels.
2. Click on the “Settings” icon in the top right corner of the dashboard.
3. In the settings menu, click on “Variables.”
4. Click on the “New” button to add a new variable.
5. In the Variable settings, set the variable name and choose the data source as ClickHouse.
6. Use the Query field to set the ClickHouse query that will retrieve the labels you want to display. For example, you can use a query like “SELECT DISTINCT label_name FROM table_name” to get unique values for a specific label.
7. Customize the variable settings as needed, such as setting the variable type to “Custom” if you want to manually enter the label values.
8. Save the variable settings and go back to your dashboard.
9. Add a new panel to your dashboard and select the variable you created as the source for the label.
10. The panel should now display the labels retrieved from ClickHouse based on the query you set in the variable settings.

By following these steps, you can set labels in Grafana with ClickHouse and customize your dashboard to display the desired information.