Metabase on BigQuery

Panoply on BigQuery

1. In Panoply, click on BI Connection. Click on Send your service account JSON file to your email. When you receive the file, save it in an easy to find location. You will need it in step 8.

2. In Metabase, on the top right corner, click on the Settings icon, then choose Admin from the drop-down menu.
   

3. On the Metabase Admin screen, select Setup.
4. Under Getting set up, select Add a database.
   

5. Select BigQueryas your Database Type.
6. Give your project a name. This can be anything.
7. In the Dataset ID field, enter “panoply”.
8. Click on Select a file and attach your Service Account JSON file that you saved in Step 1.

9. You will get a pop-up when your database has been added. Click on Explore this data to start your analysis.
   
   

You have successfully connected Metabase to your BigQuery data warehouse.