Set Up Google BigQuery

Prerequisites

• A Google Cloud project with BigQuery enabled
• A dataset in the necessary location
• Permission to grant IAM access
• A clear decision about whether Vendo needs read access, write access, or both

Connect with Vendo’s Service Account

1. In Vendo, open Data → Integrations → Apps and add Google BigQuery.
2. Choose Vendo Service Account.
3. Enter the GCP project ID.
4. Copy the service-account address that the form shows.
5. In Google Cloud IAM, grant that principal the roles that the form shows for the agreed scope.
6. Go back to Vendo and select Load Datasets.
7. Choose the correct dataset and verify access.
8. Save the app.

The form checks read access and write access separately. A failed write check can be acceptable for a source that only reads data. But it stops workflows that must create or update tables.

Connect with Your Own Service Account

1. In Google Cloud, create a dedicated service account for Vendo.
2. Grant the minimum roles on the correct project and dataset.
3. Create a JSON key only if your policy permits long-lived keys.
4. In the Vendo BigQuery form, choose Bring your own service account.
5. Paste the complete JSON into Service Account JSON.
6. Enter the project and dataset IDs.
7. Save the app and run a small test sync.

Delete all local copies of the downloaded key after you store it in the approved secret system.

Verify End to End

For a source, run a schema discovery or a limited query, and compare the result with BigQuery. For a destination, send a small batch that you can identify. Then verify the target table, row count, schema, timestamps, and identifiers.

Troubleshooting

Related

• Grant service-account access
• BigQuery overview
• Destination troubleshooting