Grafana on BigQuery
  • 27 Jul 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

Grafana on BigQuery

  • Dark
    Light
  • PDF

Panoply on BigQuery

To connect Grafana to BigQuery:

  1. In Panoply, click on BI Connection in the top menu to view your connection details. Click on Send your service account JSON file to your email. Save the file where you can find it for Step 9.

grafana bi connection.png

  1. Log In to your Grafana account. Under Configuration > Select Plugins.

grafana-1-1.png

  1. To connect to Google BigQuery, an additional plugin needs to be installed. Click on Find more plugins on**Grafana.com.**

grafana-2-1.png

  1. Search and download the BigQuery Plugin from Grafana Labs.

grafana-3-1.png

  1. Click on Install Plugin.

grafana-4-1.png

  1. Google BigQuery Plugin has been successfully installed.

grafana-5-1.png

  1. Return to Grafana.net. Under Configuration > Data Source > Type Google BigQuery in the search bar. Click on Add data source.

grafana-6-1.png

  1. You have successfully added Google BigQuery as your Data Source. Click on Select to connect.

grafana-7-1.png

  1. Click Upload Service Account key file and upload the file you saved in Step 1.

grafana-8-1.png

  1. Uploaded key details will be populated. Click on Save & Test.

grafana-9-1.png

  1. You have successfully tested the connection.

    grafana-10-1.png

  2. Go to the Explore Section.

grafana 11.png

  1. Select Google BigQuery from the drop-down menu.

grafana-12.png

  1. Select your project, dataset, and table from the drop-down menu. Click on Run Query.

grafana-13.png

You have successfully connected Grafana to your BigQuery data warehouse.


Was this article helpful?