BigQuery Job User (distinct from BigQuery User)įor more information on roles in BigQuery, see Google Cloud Platform’s documentation.Make sure you add the following roles to the service account: You’ll need to add roles to the service account so that Metabase will have permission to view and run queries against your dataset. Grant the service account access to this project. Name the service account, and add a description (the service account ID will populate once you add a name). At the top of the screen, click on + CREATE SERVICE ACCOUNT.įill out the service account details. The console will list existing service accounts, if any. From your Google Cloud Platform project console, open the main sidebar menu on the left, go to the IAM & Admin section, and select Service account. Here’s the basic flow:Ĭreate service account. To create the service account JSON file, follow Google’s documentation on setting up a service account for your BigQuery dataset. Service accounts are intended for non-human users (such as applications like Metabase) to authenticate (who am I?) and authorize (what can I do?) their API calls. You’ll first need a service account JSON file that Metabase can use to access your BigQuery dataset. Google Cloud Platform: creating a service account and JSON file
This project should have a BigQuery dataset for Metabase to connect to.
#METABASE GCP HOW TO#
Consult the Google Cloud Platform documentation for how to create and manage a project. You’ll need to have a Google Cloud Platform account with a project you would like to use in Metabase. To add a database connection, click on the gear icon in the top right, and navigate to Admin settings > Databases > Add a database.
0 kommentar(er)
