Understand the data differences between Amplitude, Snowflake, and the Export API

Amplitude charts, Snowflake data, Redshift data, and Export API results can show different data for the same date range. These differences often relate to the event time that each platform uses. Snowflake and the Export API use UTC event time. Amplitude charts use the project's configured time zone.

Why Amplitude and Snowflake data can differ

If the Amplitude project time zone differs from UTC, Amplitude charts and Snowflake can show different data.

When you compare data, compare equivalent queries. For example, if you query event totals in Snowflake, compare those results to the event totals tab in the Event Segmentation chart.

Why Amplitude and Export API data can differ

The date range in an Export API query uses the time when Amplitude servers received the event data. This time corresponds to the server_upload_time field.

Because Export API queries use server_upload_time, Export API results can differ from the data shown in Amplitude charts.

Was this helpful?