How-to guideSourcesAvailable
Shopify to BigQuery
Send Shopify commerce records and storefront events to BigQuery without duplicating the canonical BigQuery setup and schema references.
Last reviewed July 13, 2026
Use this workflow when Shopify is the source and BigQuery is the destination. Vendo loads server-side commerce records and first-party storefront events into a queryable warehouse dataset.
Before you start
- Connect Shopify as a source.
- Confirm the Vendo web pixel or theme integration is collecting storefront events.
- Prepare a Google Cloud project and a service account with the permissions in BigQuery setup.
Data sent to BigQuery
| Data path | Examples | Delivery |
|---|---|---|
| Shopify Admin API | Orders, customers, products, variants, collections, refunds, fulfillments | Scheduled sync and optional historical backfill |
| Storefront tracking | Page views, product views, cart activity, checkout events | Near real time |
| Vendo models | Resolved customers, calculated properties, transformations | After the related model runs |
The canonical event names and commerce objects are documented in Shopify data model. BigQuery table definitions live in Table schemas; do not use this page as a second schema reference.
Configure the destination
- Open Data → Integrations → Destinations.
- Add BigQuery and enter the project, dataset, and service-account details.
- Test the connection before saving.
- Create or update the Shopify integration and select the BigQuery destination.
- Choose the data types and backfill range you need.
- Save, then run a small sync.
See BigQuery setup for the Google Cloud steps and least-privilege roles.
Verify
- Confirm the first job completes in Activity Logs.
- Open the configured dataset in BigQuery.
- Check that expected Shopify tables exist and contain recent rows.
- Trigger a storefront test event and confirm it appears in the event table.
- Compare one order total and one customer identifier with Shopify before starting a full backfill.
Troubleshooting
| Symptom | Check |
|---|---|
| Permission denied | Service-account roles and dataset-level access |
| Tables exist but are empty | Shopify source status, selected data types, and job row counts |
| Storefront events are missing | Web pixel/theme integration and tracking write key |
| Duplicate historical rows | Backfill range and destination deduplication keys before retrying |
| Dataset not found | Project ID, dataset location, and destination configuration |
Related
Last updated on