Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Add Millisecond Precision Support to Mixpanel Connector

Answered
Ian Smeenk User

Problem: The current Mixpanel connector truncates the event.time field to second-level precision. This lack of granularity makes it impossible to accurately order events that occur within the same second or to compute precise durations between successive actions.

Root Cause: The connector does not currently pass the time_in_ms=true parameter to the Mixpanel Export API. Consequently, the API returns timestamps in seconds instead of milliseconds.

Proposed Solution: Update the Mixpanel connector to include the time_in_ms=true parameter in API requests. We request that you either:

  1. Update the existing event.time field to support millisecond precision, or
  2. Expose a new BIGINT column (e.g., event_time_ms) to capture the full raw timestamp.

Business Impact: Without this data, we cannot reliably sort high-frequency user events or perform accurate time-based analytics in our warehouse.

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Abdul Ghaffar Fivetranner

    Hi Ian, I'm Abdul, Product Manager on the SaaS connectors team at Fivetran.

    Thanks for the detailed write-up, really appreciate you laying out the root cause and proposed solutions, it makes things much easier to evaluate on our end.

    I've added it to our backlog and should be able to prioritize it in the near term. I'll follow up with a timeline once things are slotted in.

    Thanks again, and feel free to flag anything else about your Mixpanel setup that's been a pain point.

  • Ian Smeenk User

    Hi Abdul and fellow Fivetranners!

    I wanted to ask for an approximation of when in the near-term this will get addressed. My team is trying to assess whether we will build a supplementary pipeline to get this data, or if it makes sense to wait until this has been added to Fivetran. Please let me know!

  • Abdul Ghaffar Fivetranner

    Hi Ian, thanks for checking in and for your patience. We’ve got this on our roadmap and are targeting completion by end of April. Definitely worth holding off on building a separate pipeline, we want to get this right for you on our end so you don’t have to maintain extra infrastructure. I’ll keep you posted as we make progress.

  • Abdul Ghaffar Fivetranner

    Hi Ian, quick update. This is in its final stages of review with our R&D team and should be available next week. We're adding a new column with millisecond precision rather than modifying the existing event.time field, so no breaking change to your current schema. I'll confirm again once it's live.

  • Abdul Ghaffar Fivetranner

    Hey Ian, good news, this is now live.

    Just wanted to confirm you’re seeing it on your end. Let me know if there’s anything else I can help with.

    Best,
    Abdul