Heap Connect FAQs
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…
We do not currently sync Initial User properties downstream in Heap Connect (ex Initial Marketing Channel, Initial Browser). Please refer…
To connect Heap data with your own internal systems, or to run ad-hoc SQL queries against your Heap data, check…
Heap Connect is configured on a per-environment basis. This means that each warehouse can sync to one separate destination that…
When you update or change the name of an event in the Heap app, event table names downstream will not…
The session_time column may appear within certain connect tables. This column is maintained for legacy internal use only, and should…
A given event_id across all tables corresponds with a unique event recorded by Heap. That said, the same event_id may…
Primary and foreign key constraints are not applied to the Heap Connect tables because Amazon Redshift does not enforce constraints.
You’re more than welcome to create tables and views that reference our schema, though tables and views created within the…
You can adjust the sync start time or anchor time by navigating to Integrations > Directory. Click on the warehouse…
There are several common reasons why you may see your Redshift queries running slowly. Review this guide for information on…
In accordance with Heap’s data model, where users do events, each individual user in Heap is assigned a unique user…