Heap Connect: Troubleshooting 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 don’t currently sync Initial User properties downstream in Heap Connect (ex: Initial Marketing Channel, Initial Browser). Please refer to…
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.
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 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…