Integration

Zembula + Amazon Redshift

Amazon Redshift has no fixed fields, so your team decides which columns Zembula can read. Zembula can run a SQL statement on your table and show the returned row in the email.

It's our business to grow yours

Book a demo

What Zembula can read from Amazon Redshift

Amazon Redshift holds the tables that your team loads into its warehouse, and Zembula can read rows from them. Zembula can run a SQL statement on a table and read the rows that come back. Your team picks the table and the columns, because Redshift has no fixed fields. A person table can carry a last-purchase row.

An item table can carry top sellers for each category. A loyalty column can carry a tier for each person. Zembula can find a row by a key column in your table, such as an email address or an ID. That key reaches Zembula in the image URL, from a merge tag of your email service provider.

Zembula can connect through the Redshift Data API. A call names a cluster or a serverless workgroup, a database, and either a secret or IAM credentials. Your team needs permission to get database credentials, or a secret that holds a user name and password.

DataDetailLooked up by
Query result rowsRows that a SQL statement returns from a table in your warehouse.a key column in your table, such as email or an ID
Person table valuesPer-person values that your team loads into the warehouse.a key column in your table, such as email or an ID
Item table valuesPer-item values, such as top sellers for each category.a key column in your table

How the data arrives

  • API: Zembula can run a SQL statement through the Redshift Data API and read the rows that return.
  • ESP merge tags: Your email service provider sends the key value for the row as a merge tag in the image URL.

What you need

  • IAM permission to get database credentials, or a secret with a user name and password.
  • The cluster or serverless workgroup name, and the database name.
  • An API key or a data export from Amazon Redshift. Zembula sets up the connection for you.
  • A key value for each person in your email service provider, sent as a merge tag.

Ideas for email

  • Show a person’s last purchase, read by email from a warehouse table.
  • Show top-selling items for each category from your item table.
  • Pick a banner from a loyalty tier column for each person.

Last checked: 19 November 2026.

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

See how we do it by booking a demo.