Option to send DashboardID & PanelID as custom query settings

[borismattijssen]

Context
We use Grafana quite heavily to query Clickhouse. In order to improve our observability setup, we'd like to cross-correlate Grafana dashboards with Clickhouse's query_log. This will allow us to determine which Grafana dashboard are responsible for the resource-heavy queries on our cluster.

Clickhouse custom query settings
Clickhouse allows to send custom query settings that will show up in the query log.

For example:

curl "http://localhost:8123/?query=SELECT+123&SQL_my_setting=value"

We can now find that query by:

SELECT * FROM system.query_log
WHERE Settings['SQL_my_setting'] = '\'value\'';

Request
It would be great if we could send the Grafana DashboardID and PanelID as custom query settings with each query. For example:

curl "http://localhost:8123/?query=SELECT+123&SQL_grafana_dashboard_id=xxx&SQL_grafana_panel_id=yyy"

• To make this a generic solution, the SQL_ prefix should be configurable (this could be different for different Clickhouse setups).
• I'd be happy to contribute a PR if you see this as a valuable addition to the plugin.

[SpencerTorres]

The problem with the custom settings is that they're configurable to have different prefixes. I'm not sure if they can be changed in ClickHouse cloud for example. So we would need configuration to enable them as well as configuration to define the prefix. I think the metadata suggestion we discussed in the other thread will likely be the best step forward