Home Heap Connect Heap Connect Guide Heap Connect: Overview & Setup

Read in Order

  1. Heap Connect: Overview & Setup
  2. Heap Connect: Data Schema
  3. Heap Connect: Managing Data Syncing
  4. Heap Connect: Table Relationships and Joining with Other Data
  5. Heap Connect: Identity Resolution (S3 only)
  6. Heap Connect: Initial Table Syncs (BigQuery, Redshift, & Snowflake Only)
  7. Heap Connect: Sync Frequency

Table of Contents

Was this article helpful?

Yes No

Thank you for your feedback!

Heap Connect: Overview & Setup

This doc is for: Admins Architects

This feature is only available to customers on the Premier plan or the Pro plan as an add-on. To upgrade, contact your Customer Success Manager or sales@heap.io

Overview

Heap Connect is an analytics infrastructure that allows you to tackle complex analyses and directly query your raw event data. A few things you might want to use Connect for include:

  • Join Heap data with other sources (revenue data, Salesforce data, marketing automation, etc.)
  • Perform ad-hoc, custom analysis with SQL
  • Create custom visualizations and dashboards in your BI tool of choice (e.g. Looker, Mode, Chartio, Periscope, and more)
  • Build predictive user models

Because Heap Connect includes all historical data from the day you installed Heap, it gives you a uniquely complete and always up-to-date dataset for all of your teams’ analysis needs.

Setup

To set up Heap Connect, jump to setup instructions for each of the warehouses we support:

For a comparative overview of each warehouse’s supported features, check out Data Warehouses: Overview.

Heap Connect is configured on a per-environment basis. This means that each warehouse can sync to one separate destination that you have licensed. For each Heap environment, you can sync up to one of each destination (BigQuery, Redshift, Snowflake, S3), though we do not support syncing more than one destination of the same type. For example, you cannot sync two different Redshift destinations within the same environment.

When considering your schema, note that client-side custom events in Heap Connect don’t have the same event-property schema as autocaptured events. Session and pageview properties are included, but event-specific properties are limited to those sent as part of the API call. For a detailed list of event schemas in Heap Connect, see Event Tables.

Analysis Examples

Once you’ve set up Heap Connect, check out our Sample Analysis guides to explore all the different ways you can analyze your data via Heap Connect. We teamed up with Mode to bring you interactive guides featuring common queries you can run, whether you’d like to access metrics like average time on site, perform detailed revenue analysis, or build lists using a particular attribution model. The visualizations can take a few seconds to load within our docs, but you can view all the reports on the Mode Reports page.

To view the actual queries behind our embedded interactive visualizations, just click the link in the bottom-left of each visualization or the menu in the top-right hand corner to expand and explore. When copying over the query to your BI tool, make sure to update the schema name from heap to _mainproduction (or any other schema you are querying).

Just Getting Started with SQL?

If you’re not already a SQL pro, don’t worry! It doesn’t take long to learn the basics. Here are some resources we recommend to get you started.