How to Add a Service Account to Your Google Cloud Project and Assign Permissions

Step 1: Open the Google Cloud Console

1. Navigate to the Google Cloud Console .
2. Select the project where you want to add the service account from the project selector dropdown.

Step 2: Navigate to IAM and Admin

1. From the left-hand menu, select IAM & Admin > IAM.
2. This will display a list of all existing members and their roles.

Step 3: Add the Service Account

1. Click the Grant Access button at the top of the page.
2. In the “New principals” field, enter the following service account email address:

mixpanel-integration-sa@gam-dwh.iam.gserviceaccount.com

Step 4: Assign Permissions

Assign the following roles:

• BigQuery Data Viewer — Allows the service account to read data from existing tables
• BigQuery Data Editor — Grants the ability to create and update datasets and tables
• BigQuery Job User — Necessary to run queries and perform table copy operations

1. Under “Select a role,” search for and select the roles mentioned above.
2. Click Save to finalize.

Step 5: Verify the Service Account

Return to the IAM section and ensure the service account is listed with the correct roles.