Google BigQuery Source
Use an authorized BigQuery dataset as a governed source for Vendo queries and models.
Last reviewed September 15, 2026
Direct source: Vendo can query tables and views in an authorized BigQuery dataset. The connection can use Vendo’s managed service account or a service account owned by your organization.
Use Cases
- Explore an existing warehouse table.
- Bind warehouse fields to Vendo’s data model.
- Build transformations, metrics, audiences, or reports from governed data.
- Query an existing GA4 export or another customer-managed dataset.
Access Model
The BigQuery app is shared by source and destination workflows. For a read-only source, grant only the permissions needed to inspect metadata and run queries. Select the specific dataset in the connection form and use dataset-level access where practical.
See BigQuery setup for the two supported credential modes and the current form workflow.
Connect the Source
- Open Data → Integrations → Apps and add Google BigQuery.
- Choose the managed or customer-owned service-account mode.
- Enter the Project ID.
- Grant the current principal access.
- Click Load Datasets.
- Select the intended dataset.
- Click Verify Access to verify read access.
- Click Connect App.
- Create or configure the source workflow that uses the app.
- Discover the schema and classify the tables or fields needed downstream.
Verify
Run a limited query and compare its row count, columns, timezone, and sample identifiers with BigQuery. Confirm that query billing and audit logs appear in the expected GCP project.
Troubleshooting
| Symptom | Check |
|---|---|
| Dataset missing | Project ID and dataset IAM for the selected principal |
| Query denied | Data Viewer on the dataset and Job User on the execution project |
| Table missing | Dataset selection, view authorization, and schema discovery |
| Unexpected cost | Query project, partition filters, selected columns, and scan volume |