Context and Goal:
Migrating from doitintl/bigquery-grafana to the official grafana-bigquery-datasource.
Grafana version: grafana-12.0.0-1.x86_64
Plugin version: grafana-bigquery-datasource @ 2.1.0
What Works:
Panels on my dashboards are successfully displaying data using the new data source grafana-bigquery-datasource (tested using table format).
The data source itself tests successfully in Grafana.
What Doesn’t Work (The Problem):
My template variables, specifically those using BigQuery queries, are not populating values.
The “Preview of values” section in the variable editor remains empty.
Specific Error Messages:
Relevant Configuration/Code :
Template Variable Configuration (from Grafana UI and related query used):
The exact query used for the variable:
SELECT 1 AS value
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5;
Screenshot of the variable edit page showing the query, data source, and empty “Preview of values”.
Variable type: Query,
Data source selected: grafana-bigquery-datasource,
Refresh setting: On Dashboard Load.
Grafana Server Logs (debug level for query_data and plugin.grafana-bigquery-datasource):
Example log entries:
logger=plugin.grafana-bigquery-datasource t=2025-07-20T10:44:47.580232571Z level=debug msg="Plugin Request Started" dsUid=deshi3q3ofim8f ...
logger=plugin.grafana-bigquery-datasource t=2025-07-20T10:44:48.159702682Z level=info msg="Plugin Request Completed" dsName=grafana-bigquery-datasource dsUid=deshi3q3ofim8f pluginId=grafana-bigquery-datasource status=ok ...
Note: The status=ok indicates the query completed successfully from the plugin’s perspective, but no values appear in the variable.
Additional Issue:
When manually updating the data source in old dashboards (previously pointed to doitintl/bigquery-grafana) to the new grafana-bigquery-datasource, I encountered the following error:
error unmarshaling query JSON to the Query Model: json: cannot unmarshal string into Go struct field Query.format of type sqlutil.FormatQueryOption
Request:
Please help me understand what’s wrong and how to fix it. Thank you!