Mixpanel Migration Guide

Availability

Core Standard Pro Enterprise Flex Self-Managed Enterprise PyAirbyte

Support Level

Marketplace

Connector Version

3.6.1 (last updated 2 months ago)

CDK Version

6.45.0

Sync Success Rate

Usage Rate

Definition ID

12928b32-bf0a-4f1e-964f-07e12e37153a

Upgrading to 3.0.0

In this release, we introduce breaking change for CohortMembers stream:

• State is changed to per-partition format.
• Key is changed to a unique key (based on distinct_id and cohort_id fields). The previous key was not unique and didn't support the possibility for user be in multiple cohorts.

To gracefully handle these changes for your existing connections, we highly recommend resetting your data before resuming your data syncs with the new version.

note

To add start date filtering for the Cohorts, CohortMembers, and Engage streams, the default retrieval range has been updated from all existing records to only include records created within the past year if start date not provided.

Connector upgrade guide

Help with upgrades.

Refresh affected schemas and reset data

1. Select Connections in the main nav bar.
   1. Select the connection(s) affected by the update.
2. Select the Replication tab. 1. Select Refresh source schema. 2. Select OK.
   note

   Any detected schema changes will be listed for your review.

3. Select Save changes at the bottom of the page. 1. Ensure the Reset affected streams option is checked.
   note

   Depending on destination type you may not be prompted to reset your data.

4. Select Save connection.
   note

   This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

Upgrading to 2.0.0

In this release, the default primary key for stream Export has been deleted, allowing users to select the key that best fits their data. Refreshing the source schema and resetting affected streams is necessary only if new primary keys are to be applied following the upgrade.

Upgrading to 1.0.0

In this release, the datetime field of stream engage has had its type changed from date-time to string due to inconsistent data from Mixpanel. Additionally, the primary key for stream export has been fixed to uniquely identify records. Users will need to refresh the source schema and reset affected streams after upgrading.