Heap Connect: Getting Started FAQs

What is a join key?

A join key is a user property used to match users in Heap to another source. When you connect Heap…

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…

Can I create tables and views within the Heap schema?

You’re more than welcome to create tables and views that reference our schema, but they should be kept in a…

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…