BigQuery

Setup BigQuery Integration To Mitzu

Overview​

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

• Grant Permissions to a Mitzu-owned Service Account

• Your BigQuery Project ID

Grant Permissions to Mitzu's Service Account​

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

1. In your BigQuery's IAM & Admin settings, add the Statsig service account you copied in the Statsig Console as a new principal for your project, and give it the following roles:

   • BigQuery User

   • BigQuery Data Viewer

   • BigQuery Job User

   • BigQuery Read Session User

Big Query Mitzu Service Account Roles

2. Create BigQuery JSON Key at https://console.cloud.google.com/iam-admin/serviceaccounts/

Create JSON Key

3. Copy credentials to Mitzu workspace settings

Copied Credentials to Connection Page

4. Add tables from Bigquery. Follow here.