Data Warehouses: Overview

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 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

most relevant results

developer center results