BigQuery

Setup BigQuery Integration To Mitzu

Overview​

To set up connection with BigQuery, we need the following:

• IAM Service Account with the 4 permissions regarding BigQuery

• Your BigQuery Project ID

Grant Permissions to Mitzu's Service Account​

You need to grant 4 permissions for Mitzu from your Google Cloud console in order for us to access your BigQuery data.

1. In your GCP console create a Service account.
2. Add 4 roles to this account:

   • BigQuery User

   • BigQuery Data Viewer

   • BigQuery Job User

   • BigQuery Read Session User

3. Click Done
4. Create BigQuery JSON Key by clicking on the Manage Keys button
5. Save the key at a secure location

6. Copy credentials to Mitzu workspace settings and set the BigQuery project id.

Copied Credentials to Connection Page

4. Add tables from Bigquery. Follow here.