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

In some cases, you may notice differences between your Amplitude data and the data in both Snowflake and Redshift, or data exported using the Export API. Often, these are related to the event time used by each platform. In Snowflake, as well as data exported using the Export API, event time is specified in UTC timezone. The data shown in Amplitude charts depends on the timezone settings for the project.

Difference between Amplitude and Snowflake

If the timezone setting for the Amplitude project is different than UTC, you will likely see differences in the data shown in Amplitude charts compared to the data in Snowflake. 

When comparing data, make sure you are comparing the same queries. For example, if you query data for event totals in Snowflake, be sure to check the event totals tab in the Event Segmentation chart. Learn more in our Help Center article on SQL in Amplitude.

Difference between Amplitude and Export API

The specified date range for the export query is the time of when the event data was uploaded to Amplitude servers (see server_upload_time definition).

For that reason, you can expect differences in the data shown in Amplitude charts when compared with the data from the export API.

Was this page helpful?

Thanks for your feedback!

July 15th, 2024

Need help? Contact Support

Visit Amplitude.com

Have a look at the Amplitude Blog

Learn more at Amplitude Academy

© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.