Mixpanel is a business analytics service that tracks user interactions with web and mobile applications. The data collected is used to build custom reports and measure user engagement and retention.
|Capture Deletes||Mixpanel doesn't support deletes|
|Custom Data||check||All tables and fields|
|Data Blocking||check||Table level and schema level|
Follow our step-by-step Mixpanel setup guide to connect Mixpanel with your destination using Fivetran connectors.
During the initial sync, our system pulls all events from the last 30 days. After the initial sync has completed, we start pulling historical events at regular intervals. It might take a few days for all historical events to end up in your warehouse.
This schema applies to all Mixpanel connectors.
EVENT.event_id is a fivetran-generated attribute that was formerly the primary key.
EVENT._fivetran_id is the new primary key.
_fivetran_id is a hash of the contents of the event;
event_id is now simply the timestamp, converted to a long.
Pre-built dbt packages
Fivetran integrates with data build tool (dbt) to power complex transformations. Our pre-built Mixpanel dbt package produces clear, comprehensible tables that power your reports, visualizations, and dashboards. Find the package in Fivetran's dbt hub.
You can use Fivetran-created dbt packages with several destinations. Find a complete list of supported destinations in our dbt documentation.