Sync data from Amazon Redshift to HubSpot

Your favorite companies use Hightouch to sync data securely at scale.Our customers

Activate your data in 3 easy steps

Step 1

Connect your source and destination

Connect to 25+ data sources, like Amazon Redshift, and 200+ destinations, like HubSpot.

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 HubSpot objects can you sync to?

• Contacts

  Contacts store information about individuals. From marketing automation to smart content, the lead-specific data found in contact records helps users leverage much of HubSpot's functionality.

  Hightouch docsHubSpot API

• Companies

  The companies object is a CRM object. You can use individual company records to store information about businesses and organizations within company properties. The companies endpoints allow you to manage this data and sync it between HubSpot and other systems.

  Hightouch docsHubSpot API

• Deals

  A a deal represents an ongoing transaction that a sales team is pursuing with a contact or company. It’s tracked through pipeline stages until won or lost. The deals endpoints allow you to manage this data and sync it between HubSpot and other systems.

  Hightouch docsHubSpot API

• Tickets

  In HubSpot, a ticket represents a customer request for help or support. The tickets endpoints allow you to manage this data and sync it between HubSpot and other systems.

  Hightouch docsHubSpot API

• Custom Objects

  To represent and organize your CRM data based on your business needs, you can create custom objects. Use the custom objects API to define custom objects, properties, and associations to other CRM objects before syncing data from Hightouch.

  Hightouch docsHubSpot API

• Events

  A marketing event is a CRM object, similar to contacts and companies, that enables you to track and associate marketing events, such as a webinar, with other HubSpot CRM objects. Below, learn more about working with the marketing event API to integrate marketing events into an app.

  Hightouch docsHubSpot API

What methods can I use to model my Amazon 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 Amazon Redshift.

• Sigma model

  

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

• Table selector

  

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

• Customer Studio

  

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

FAQs