Heap Connect FAQs

Why are there duplicate event IDs in the All Events view in my data warehouse?

Some duplicate pairs (user_id, event_id) can be expected in the all_events table, as long as the event_table_name value is different…

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…

How do I get data out of Heap?

To connect Heap data with your own internal systems, or to run ad-hoc SQL queries against your Heap data, check…

Can I sync to more than one warehouse via Heap Connect?

Heap Connect is configured on a per-environment basis. This means that each warehouse can sync to one separate destination that…

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

When you update or change the name of an event in the Heap app, event table names downstream will not…

Where is the session_time column?

The session_time column may appear within certain connect tables. This column is maintained for legacy internal use only, and should…

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 Integrations > Directory. Click on the warehouse…

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…

Why am I seeing duplicate events or session IDs?

In accordance with Heap’s data model, where users do events, each individual user in Heap is assigned a unique user…