Sync data from Redshift to Iterable

The world's most innovative companies choose Hightouch as their Composable CDP

Activate your data in 3 easy steps

Step 1

Connect your source and destination

Connect to 35+ data sources, like Redshift, and 200+ destinations, like Iterable.

Step 2

Define your model

Use SQL or select an existing dbt or Looker model.

Step 3

Sync your data

Map your fields, set your sync schedule, and hit “Go!”

Email

Email

Name

Name

Total_orders

All_orders

Last_login

Last_login

What Iterable objects can you sync to?

• Users

  Every email address you have in Iterable is a user or subscriber/contact. You can use Hightouch to update user information or delete, forget, or unforget users.

  Hightouch docsIterable APIIterable User Profile Overview

• Events

  An event is an action a user takes on your website or app. They are specific to your business. Use Hightouch to send shopping cart, purchase, or custom events to Iterable.

  Hightouch docsIterable APIIterable Events Overview

• Catalogs

  When sending messages to your users, it's almost always necessary to include information about your organization's products, places, events, or services. Use Hightouch to send this information directly to Iterable.

  Hightouch docsIterable APIIterable Catalog Overview

• Segments

  Iterable's segmentation tool allows you to segment across all of your subscribers and to make static or dynamic lists. Use Hightouch to add users to lists to create highly targeted customer segments, so you can deliver the most relevant marketing messages.

  Hightouch docsIterable APIIterable Segmentation Overview

What methods can I use to model my Redshift data?

• dbt model selector

  

  Sync directly with your dbt models saved in a git repository.

• Looker

  

  Query using Looks. Hightouch turns your look into SQL and will pull from your source.

• SQL editor

  

  Create and Edit SQL from your browser. Hightouch supports SQL native to Redshift.

• Sigma model

  

  Hightouch converts your Sigma workbook element into a SQL query that runs directly on Redshift.

• Table selector

  

  Select available tables and sheets from Redshift and sync using existing views without having to write SQL.

• Customer Studio

  

  For less technical users, pass traits and audiences from Redshift using our visual segmentation builder.

FAQs