grafana / google-bigquery-datasource

Google BigQuery Datasource Plugin for Grafana.
Apache License 2.0
26 stars 13 forks source link

Feature Request: Include dashboard metadata as query header #197

Closed HbirdJ closed 2 months ago

HbirdJ commented 1 year ago

I work with a Grafana OSS deployment connected to BigQuery, and have run into issues with users creating queries that habitually time out and/or use excessive BQ slots. Tracking down the dashboard they're coming from is a bit of a headache, and some sort of header information I could look at on the BQ console side of things would make tracking down the problem dashboard much easier.

This idea comes from something I've seen with dbt. It includes a header akin to the following in every query it sends to BQ:

/* {"app": "dbt", "dbt_version": "1.5.1", "profile_name": "<project>", "target_name": "api-production", "node_id": "model.<project>.<model_name>"} */

A grafana relevant implementation would include things like dashboard source and panel information.

HbirdJ commented 2 months ago

Closing because it's effectively solved by this feature: https://github.com/grafana/google-bigquery-datasource/pull/241