Integration

Zembula + Snowflake

Snowflake stores whatever tables you load, so the rows in an email image can come from your own customer, order and product tables. Zembula runs your SQL query and reads the rows back.

It's our business to grow yours

Book a demo

Zembula has built this integration.

What Zembula can read from Snowflake

Zembula runs a SQL query against your own Snowflake account and reads the rows back into an email image. The rows come from the tables that you load into Snowflake, so the data is yours. Customer, order and product tables are typical kinds of data to load. The query takes a lookup value as a bind variable in the WHERE clause, such as an email address or an id.

That returns the rows for one person. A banner can then show the last orders of that person, or items from your product table. Your team pastes its Snowflake account details into Zembula. The connection needs a user with an OAuth token or a registered key pair, and a role and a warehouse that can run the query.

Table names and columns are your own. Snowflake can also send an alert notification to a webhook, which is a second route for data. Your email service provider carries the email address or id of each person into the image URL as a merge tag.

DataDetailLooked up by
Query result rowsRows that a SQL query returns from your own tables.a bind variable such as email or id in the WHERE clause
Customer table rowsRows from a customer table that you load into Snowflake.a bind variable in the WHERE clause
Order table rowsRows from an order table that you load into Snowflake.a bind variable in the WHERE clause
Product table rowsRows from a product table that you load into Snowflake.a bind variable in the WHERE clause

How the data arrives

  • API: Zembula runs your SQL query against your own Snowflake account and reads the rows back.
  • Webhook: A SQL statement in Snowflake can send an alert notification to a webhook.
  • ESP merge tags: A merge tag carries the email address or id of each person into the image URL.

What you need

  • Your Snowflake account details, which you paste in Zembula.
  • A Snowflake user with an OAuth token or a registered key pair.
  • A role and a warehouse that can run your query.
  • An email address or an id for each person, sent as a merge tag in the image URL.

Ideas for email

  • Show the last order rows of a person, looked up by email, in an order email.
  • Pick items from your product table for a banner.
  • Use a row from your customer table to choose banner copy for a person.

Last checked: 19 November 2026.

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

See how we do it by booking a demo.