Home Heap Connect Data Warehouses Data Warehouses: Overview

Table of Contents

Was this article helpful?

Yes No

Thank you for your feedback!

Data Warehouses: Overview

In this article you'll learn:

  • An overview of features supported by the different destinations that Heap Connect syncs to
This doc is for: Admins Architects

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.

RedshiftBigQuerySnowflakeRetroactive S3
Supported Sync FrequencyOnce every 24 hoursOnce every 24 hoursOnce every 24 hoursOnce every 24 hours
Segment SyncingSupportedNot SupportedSupportedNot Supported
Defined Properties SyncingSupportedSupported**SupportedSupported
User Migration SyncingSupportedSupportedSupportedSupported
User Migrations Applied on TablesAutomaticAutomaticAutomaticManually Applied*

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