Integration

Zembula + Google BigQuery

BigQuery runs your SQL, so Zembula can show the rows that a query returns for one person.

It's our business to grow yours

Book a demo

Zembula has built this integration.

What Zembula can read from Google BigQuery

BigQuery stores your tables and runs SQL on them. When a person opens your email, Zembula can run a SQL query against your project and show the rows that come back. The query filters on a person key, so it returns the rows for one person. Zembula can also read a dataset by its ID.

A dataset is a named group of tables in your project. The tables hold person, order and product data in your own schema, so the field names are yours. A marketer can pick an email block from the last category that a person bought. A marketer can query a table by person ID to vary a send.

A marketer can run a query on order rows to choose a post-purchase product. You connect by pasting your connection details into Zembula. 0 credentials. On projects that use on-demand pricing, up to 200 TiB of queries can run each day.

You can change this limit at any time. Your email service provider supplies the person key as a merge tag in the image URL.

DataDetailLooked up byHow fresh
Query resultsRows that a SQL query returns from your project.a SQL WHERE on a person keyopen time
DatasetsA named group of tables in your project.dataset idopen time
TablesRows of person, order or product data in your own schema.table idset at setup

How the data arrives

  • API: Zembula can run SQL queries and read datasets and tables through the BigQuery REST API.

What you need

  • Connection details for your BigQuery project, which you paste in Zembula.
  • A person key in your email service provider, sent as a merge tag in the image URL.
  • Tables that hold your person, order or product data.

Limits to plan for

LimitWhat it means
On projects that use on-demand pricing, up to 200 TiB of queries can run each day. You can change this limit at any time.Plan your query volume against this daily cap.

Ideas for email

  • Query a person’s last purchased category to pick an email block.
  • Query a table by person ID to vary the content of a send.
  • Run a SQL query on order rows to show a post-purchase product.

Last checked: 19 November 2026.

Performance marketing dials, inside email. For the first time.

See how we do it by booking a demo.