Heap Connect FAQs

Why don’t I see initial user properties in Heap Connect?

We do not currently sync Initial User properties downstream in Heap Connect (ex Initial Marketing Channel, Initial Browser). Please refer…

What happens when I change the name of a synced event or category name in Heap Connect?

When updating an event or category name, you may see the following pop-up warning you that the event is synced…

Why is a given event_id included more than once on the all_events table?

A given event_id across all tables corresponds with a unique event recorded by Heap. That said, the same event_id may…

Why are constraints not applied to the tables?

Primary and foreign key constraints are not applied to the Heap Connect tables because Amazon Redshift does not enforce constraints.

Can I create tables and views within the Heap schema?

You’re more than welcome to create tables and views that reference our schema, though tables and views created within the…

How do I adjust the sync start time or anchor time?

You can adjust the sync start time or anchor time by navigating to Integrate > Connect. Click on the warehouse…

Can I adjust the sync frequency?

You can adjust the sync start or anchor time, but not the frequency. If you need more frequent syncs, please…

How can I improve Redshift query performance?

There are several common reasons why you may see your Redshift queries running slowly. Review this guide for information on…