Metabase on BigQuery

Metabase on BigQuery

Panoply documentation is moving! Click here to view the new site!  __________________________________________________________________________________________________________________

To determine whether your data warehouse is built on BigQuery or Redshift, see the BI Connect Page on the Panoply platform.

Panoply on BigQuery

To connect Metabase to 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.

Getting started is easy! Get all your data in one place in minutes.
Try Panoply Free