BigQuery Setup Instructions

Prerequisites

• A Google Cloud Platform (GCP) account
• A BigQuery project (or ability to create one)
• A Vendo account with an active workspace

Step 1: Create a BigQuery Project

If you don’t already have a GCP project:

1. Go to Google Cloud Console 
2. Create a new project or select an existing one
3. Enable the BigQuery API (APIs & Services > Enable APIs)
4. Note your Project ID (visible in the project selector)

Step 2: Choose Your Connection Method

Vendo offers two ways to connect to your BigQuery project:

Option A: Vendo Managed Service Account (Recommended)

The simplest approach — grant Vendo’s service account access to your project. No keys to download or manage.

1. In GCP Console, go to IAM & Admin > IAM
2. Click Grant Access
3. In the New principals field, enter:

vendo-connect@gam-dwh.iam.gserviceaccount.com

4. Assign these roles:
   • BigQuery Data Viewer — read access to existing tables
   • BigQuery Data Editor — create and update datasets and tables
   • BigQuery Job User — run queries and load data
5. Click Save

For detailed steps with screenshots, see Grant Access to Vendo.

Option B: Bring Your Own Service Account

If you prefer to use your own service account (e.g., for tighter access control):

1. In GCP Console, go to IAM & Admin > Service Accounts
2. Click Create Service Account
3. Name it (e.g., “Vendo Integration”)
4. Grant the same three roles listed above
5. Create a JSON key and download it
6. You’ll upload this key in the next step

Step 3: Configure in Vendo

1. In your Vendo workspace, go to App Connections > Add App
2. Select Google BigQuery
3. Choose your connection method:
   • Vendo Service Account — enter your GCP Project ID, click Load Datasets, and select your dataset
   • Bring Your Own — enter your Project ID and upload the JSON key file
4. Click Save to connect

Step 4: Verify Connection

1. Vendo will automatically create or detect datasets in your project
2. Check BigQuery Console for the new dataset
3. Tables will be created as data flows in

What Happens Next

After setup completes:

• Datasets appear in your BigQuery project
• Tables are created for each connected data source
• Data imports begin based on your source schedule
• Models and exports can reference your BigQuery data

Troubleshooting

Permission Denied

• Verify the service account has all three roles (Data Viewer, Data Editor, Job User)
• Check you’re in the correct GCP project
• For managed mode: ensure vendo-connect@gam-dwh.iam.gserviceaccount.com is listed in IAM

Dataset Not Loading

• Click Load Datasets after entering the Project ID
• Ensure BigQuery API is enabled in your GCP project
• Check that the service account has access to the specific project

Connection Errors (BYOSA)

• Re-download the service account JSON key
• Verify the JSON file is valid (not truncated)
• Check the Project ID matches the key’s project