Home Heap Connect Heap Connect FAQs

Heap Connect FAQs

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…
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…
Can I adjust the sync start time or anchor time?

Sync completion time depends on when the sync starts, so adjusting the start time makes the data available at different…
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…