Release Noteslink

September 2023link

We have added new Quickstart packages for the following connectors:

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

March 2023link

We have changed the primary key of the EVENT table to avoid duplicate events from Mixpanel. We have removed the time column and now use only the _fivetran_id column as the primary key. For event records after July 1, 2021, we calculate the _fivetran_id value as the hash of the insert_id, distinct_id, and name columns. New connectors created after March 19, 2023, will support this feature by default. We are gradually rolling out this improvement to all the existing connectors.

June 2022link

You can now exclude the CAMPAIGNS child table from your syncs. On your Connector Details page, go to the Schema tab and deselect the table.

NOTE: If you exclude the table and later want to sync the table, perform a complete table re-sync of the parent PEOPLE table, because we don't maintain the state of the child table due to a lack of timestamp support in the source.

We now display tables on the Schema tab in a nested parent-child format. If you want to sync a child table, you must include the parent table in the sync.

April 2022link

We no longer sync the event_id column to the EVENT table. We now use the system column _fivetran_id to identify unique records. Previously, we used the event_id column to identify unique records.

February 2022link

We have added a new optional field, Data Region, to the connector setup form. If your Mixpanel data resides in the European Union, select the Data Region as EU.

September 2021link

You can now exclude the following child tables from your syncs:

ANDROID_INVALID_PUSH_TOKENS
COLLECTIONS
DELIVERIES
JOURNEYS
MP_INAPP_CAMPAIGNS
RESPONSES
SURVEYS
SURVEY_COLLECTIONS
SURVEY_RESPONSES

On your Connector Details page, go to the Schema tab and deselect the tables.

NOTE: If you exclude the tables and later want to sync the tables, perform a complete table re-sync of the parent PEOPLE table, because we don't maintain the state of the child tables due to a lack of timestamp support in the source.

August 2021link

We have changed our sync strategy and now retrieve events data from Mixpanel using Processing Time event.mp_processing_time_ms. Previously, we used Event Time event.time. During internal performance testing, we observed a reduction in sync time. To ensure data integrity, we have rolled back the EVENT table’s cursor by six days. As a result of this rollback, you may observe a longer sync duration in your next sync.

You can now exclude the following tables from your syncs:

ANSWER
ANDROID_DEVICE
IOS_DEVICE
TRANSACTION

To exclude these tables, go to the Schema tab of your connector details page and deselect them.

NOTE: If you deselect these tables and later reselect them, you must manually re-sync the tables, because we don't maintain their state due to a lack of timestamp support in the source.

June 2021link

We now use the _fivetran_id and time columns as the schema's primary keys to support Mixpanel's deduplication logic. We select the _fivetran_id value based on the following conditions:

For connectors created before November 20, 2020, we select the _fivetran_id value based on the following conditions:
- If the record's event.time value is before July 1, 2021, we calculate the _fivetran_id value by generating the hash for the entire record.
- If the record's event.time value is after July 1, 2021, we use the record's insert_id value as the _fivetran_id value.
For connectors created after November 20, 2020, we use the record's insert_id value as the _fivetran_id value.

We now sync the event.time field as TIMESTAMP_NTZ. Previously, we synced the field as TIMESTAMP_TZ.

January 2021link

The Mixpanel connector now supports projects that are hosted in the European Union (EU) region. You can now sync event data from data stores located in the EU.

October 2020link

We have released a pre-built, dbt Core-compatible data model for Mixpanel. Find the model in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

November 2019link

The Mixpanel connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Mixpanel's priority-first syncs fetch the most recent 15 days' worth of data from the EVENT table.

To learn more, see our priority-first sync documentation.

December 2018link

During its initial sync, the Mixpanel connector now syncs 30 days' worth of recent data, followed by alternating syncs of historical and recent data. This ensures that you see your most recent data right away.

June 2018link

We have added a new table, CAMPAIGN, which includes campaign names.

Documentation