![]() Upload the service account JSON file you created when following the steps above. For example, if your ID is project_name:project_id, only enter project_id. When entering the Project ID, omit the Project ID prefix. If you’re not sure where to find the Project ID, see Google’s documentation on getting information on datasets. You can find this ID via the Google Cloud Console. Project ID (override)Įach BigQuery dataset will have a Project ID. Name is the title of your database in Metabase. Metabase will present you with the relevant configuration settings to fill out: Settings Display name On the ADD DATABASE page, select BigQuery from the Database type dropdown. In the Databases section, click on the Add database button in the upper right. Once you have created and downloaded your service account JSON file for your BigQuery dataset, head over to your Metabase instance, click on the settings cog, and select Admin to bring up Admin mode. If you delete the key, you’ll need to create another service account with the same roles. The JSON file will download to your computer. Once you have assigned roles to the service account, click on the Create Key button, and select JSON for the key type. 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. 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. Connecting Metabase to Google Drive data sources.Google Cloud Platform: creating a service account and JSON file.This page provides information on how to create and manage a connection to a Google BigQuery dataset, including one that uses files stored in Google Drive as a data source, like Google Sheets (GSheets). Working with Google BigQuery in Metabase.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |