Grafana on BigQuery

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.
   

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

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

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

5. Click on Install Plugin.
   

6. Google BigQuery Plugin has been successfully installed.
   

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

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

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

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

11. You have successfully tested the connection.
    
    

12. Go to the Explore Section.
    

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

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

You have successfully connected Grafana to your BigQuery data warehouse.