Skip to content
  • Home
  • Developers
  • API
  • Releases
  • Community
  • University
  • Status
  • Home
  • Developers
  • API
  • Releases
  • Community
  • University
  • Status
Home Heap Connect Heap Connect Guide Heap Connect: Managing Data Syncing
Session Replay Getting Started Administration Data Management Definitions Charts Analysis Examples Heap Plays Integrations Heap Connect Data Privacy

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: Managing Data Syncing

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.

As you define new events and modify existing events, we seamlessly update your cluster schema. This ensures that the data is always a clean, accurate representation of your data.

In particular, the following changes can happen on each sync:

  • When an event is toggled to sync for the first time, we create a new table for that event.
  • When a defined event is modified in the Heap interface, we tear down the existing table for that event, create a new one in its place, and populate the new table.
  • Archiving events and properties that are synced downstream will pause these syncs indefinitely until they are restored. Specifically:
    • Archived events will stop syncing downstream. Unarchiving these events will cause a new, full sync of the table.
    • Archived properties will stop syncing downstream (the column will remain but it will be empty). Unarchiving these properties will cause the property to sync again, but there might be a gap in the table (with no backfill occurring). 
  • When a custom event property is seen for the first time, we add a new property column to the corresponding event table.
  • When a custom user property is seen for the first time, we add a new user property column to the users table.
  • When user-level properties are updated with heap.addUserProperties, we update corresponding rows in the users table.
  • When an anonymous user gets identified with an existing identity via heap.identify, we “migrate” the user by running an update on the users table and another update on all event tables that reference the anonymous user’s user_id.

Toggle Multiple Events or Segments To Sync

You can toggle multiple events or segments to sync from the Definitions > Events or Segments page. Click the checkbox next to the event or segment, then click the Sync icon next to x events/segments selected.

You’ll be prompted to select your warehouse from the data warehouse drop-down, then confirm that you want to enable the selected events to be synced to the selected warehouse.

Toggle Multiple Properties To Sync/Unsync

Syncing / Unsyncing properties do not resync the full data set, so it won’t impact sync performance!

You can toggle multiple properties to sync or unsync. Unsyncing properties allows you to prevent the buildup of table cruft downstream, which can impact your sync performance.

To sync or unsync properties, from Definitions > Properties, click the checkbox next to the property, then click the sync or unsync icon next to x properties selected.

You can select an entire category by first selecting one property within that category. A checkbox will appear next to the category name which you can then select.

A pop-up will appear where you can select the warehouse(s) to sync or unsync these properties to.

Was this article helpful?

Yes No

Thank you for your feedback!

Last updated March 20, 2023.

data hierarchydata schema
  • Blog
  • Partners
  • Legal
  • Security
  • Terms
  • About
  • Careers
  • Privacy
  • Contact Us

© 2023 Heap, Inc.