Issue
Fivetran is missing some columns.
Environment
Connector: Mixpanel
Resolution
Custom fields/properties in Mixpanel are populated in the properties column as JSON objects.
Cause
Fivetran does not currently sync empty tables/columns for the Mixpanel connector. Properties with NULL values aren't synced to the destination warehouse.
All standard fields are populated in the event table. Custom fields are populated as JSON objects in the properties column.
For more information, visit Fivetran's Mixpanel Schema Documentation.