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.
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.
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.
Thanks for your feedback!
July 4th, 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.