What is the BigQuery integration?
Google BigQuery reads via SQL query or table scan and writes via streaming insertAll.
With Product Feed Master, BigQuery becomes a connector you can attach to any feed. You control exactly which products and attributes flow through it, so the data that reaches BigQuery is clean, complete, and formatted correctly.
How Product Feed Master connects to BigQuery
The BigQuery connector is powered by our BigQuery connector under the hood, so it inherits the same battle-tested authentication, retry, and scheduling behavior used across the platform.
Because BigQuery supports both directions, you can use it as a source to import products and as a destination to export your mapped catalog — or both at once for true two-way sync.
Why manage your BigQuery feed with Product Feed Master?
Maintaining a BigQuery feed by hand is slow and error-prone. Prices drift out of date, out-of-stock items keep showing, and every channel wants attributes named differently. Product Feed Master solves this by keeping one master catalog and projecting a tailored feed to BigQuery.
You map source fields to the attributes each destination expects, layer on rules to rename, combine, default, or filter values, and schedule automatic re-syncs so the data is never stale.
What you can do with the BigQuery connector
- Import products and attributes from BigQuery into your master feed.
- Export a mapped, channel-ready catalog to BigQuery.
- Map your source fields to the attributes BigQuery expects.
- Transform values with rules: rename, combine, default, format, and filter.
- Exclude out-of-stock or non-compliant products before they reach the channel.
- Schedule automatic re-syncs so your BigQuery feed never goes stale.
How to set up a BigQuery feed
Build your master feed
Create a feed and attach your product sources so Product Feed Master has a single, unified catalog to work from.
Add the BigQuery connector
Create a new channel in Product Feed Master and choose BigQuery. Enter your credentials or endpoint details — the connector handles authentication for you.
Map and transform your fields
Match your catalog attributes to the fields BigQuery expects, then add transformation rules to clean, reformat, or enrich values as needed.
Schedule and sync
Set a sync schedule — hourly, daily, or on demand — and Product Feed Master keeps your BigQuery feed up to date automatically.
BigQuery integration FAQ
Does Product Feed Master support BigQuery?
Yes. BigQuery is available as a connector you can attach to any feed in Product Feed Master, with field mapping, transformation rules, and automated scheduling included.
Can I both import and export with BigQuery?
Yes. The BigQuery connector supports two-way sync — use it to import product data, export your mapped catalog, or both.
What technology powers the BigQuery connector?
It runs on our BigQuery connector, which handles authentication, retries, and formatting so you don't have to manage any of it yourself.
Do I need to write code to connect BigQuery?
No. Connecting BigQuery is fully configuration-driven — add the connector, map your fields, and schedule a sync. No development work required.
How often can I sync my BigQuery feed?
You can sync on demand or on a recurring schedule. Pick the cadence that matches how often your prices and inventory change.