Heap Connect is an analytics infrastructure that allows you to tackle complex analysis and directly query your raw event data.
The table below lists features supported by the different destinations that Heap Connect syncs to, which are as follows:
Note for VPC users
cross-region VPC is not supported. Heap syncs from AWS s3 us-east-1. For more information, see Amazon’s documentation on working with VPC endpoints.
For more information about Heap Connect, see our Heap Connect Guide.
Sync Frequency and Start Time
If you need more frequent syncs or to adjust the sync start time, please reach out to us via the Get support page in Heap. Sync completion time depends on when the sync starts, so changing the start time makes the data available at different times throughout the day.
| Redshift | BigQuery | Snowflake | Retroactive S3 | Databricks | |
|---|---|---|---|---|---|
| Supported Sync Frequency | Once every 24 hours | Once every 24 hours | Once every 24 hours | Once every 24 hours | Once every 24 hours |
| Segment Syncing | Supported | Not Supported | Supported | Not Supported | Not Supported |
| Defined Properties Syncing | Supported | Supported** | Supported | Supported | Not Supported |
| User Migration Syncing | Supported | Supported | Supported | Supported | Supported |
| User Migrations Applied on Tables | Automatic | Automatic | Automatic | Manually Applied* | Automatic |
We don’t currently sync Initial User properties downstream in Heap Connect (ex: Initial Marketing Channel, Initial Browser). Please refer to our guidance on Creating an enhanced users table for an example of how to recreate those properties in your warehouse.
*Requires manual application of identity resolution queries.
**We do not include defined properties on the built-in pageviews or sessions tables