BigQuery Setup

Complete the following steps to get your BigQuery connector up and running:

1. Navigate to Project Settings, then select Warehouse Sources.

2. Click on + Add Connection and select BigQuery.

3. You should see a new page to create your BigQuery connector. In the first view, fill out the required field GCP Project ID.

   • Run the commands below in Cloud shell & click Create Source

   gcloud projects add-iam-policy-binding <your_gcp_project_id> \
   --member serviceAccount:project-2946576@mixpanel-warehouse-1.iam.gserviceaccount.com \
   --role roles/bigquery.dataViewer
   gcloud projects add-iam-policy-binding <your_gcp_project_id> \
   --member serviceAccount:project-2946576@mixpanel-warehouse-1.iam.gserviceaccount.com \
   --role roles/bigquery.jobUser

4. In the second view, you should see that the credentials are validated and a source is added.