BigQuery Setup Instructions

Prerequisites

• A Google Cloud Platform (GCP) account
• A BigQuery project (or ability to create one)
• Admin access to your Shopify store
• The Vendo app installed on your Shopify store

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
4. Note your Project ID

Step 2: Create a Service Account

1. In GCP Console, go to IAM & Admin > Service Accounts
2. Click Create Service Account
3. Name it “Vendo Integration”
4. Grant these roles:
   • BigQuery Data Editor
   • BigQuery Job User
5. Create a JSON key and download it

For detailed steps, see Add Service Account to GCP.

Step 3: Configure in Vendo

1. Open the Vendo app in your Shopify admin
2. Navigate to Integrations > BigQuery
3. Enter your credentials:
   • Project ID — Your GCP project ID
   • Service Account JSON — Upload or paste the JSON key
4. Vendo will automatically create the dataset and tables

Step 4: Verify Connection

1. Click Test Connection in Vendo
2. Check BigQuery for the new vendo_{shop_name} dataset
3. Tables will be created automatically
4. Historical backfill begins immediately

What Happens Next

After setup completes:

• Dataset vendo_{shop_name} appears in your BigQuery project
• Tables are created for orders, customers, products, events, and more
• Historical data loads within hours
• Real-time events begin streaming from your storefront immediately

Troubleshooting

Data Not Appearing

1. Check service account permissions — Must have BigQuery Data Editor and Job User roles
2. Verify project ID — Ensure the correct project ID is configured
3. Check dataset — Look for vendo_* dataset in BigQuery Console

Connection Errors

1. Invalid JSON key — Re-download the service account key from GCP
2. Permission denied — Verify IAM roles are assigned correctly
3. Project not found — Double-check the project ID

Stale Data

1. Check sync status — View integration status in the Vendo app
2. Verify connection — Test connection in settings
3. Review error logs — Check the errors table in BigQuery for issues