Get Started
Data
Analytics
Session Replay
Feature Experiment Web Experiment
Admin
SDKs APIs
Partners
FAQ
Overview of Amplitude Data Getting set up with Amplitude Data Autocapture Visual Labeling Data structure video walkthrough Debug with the Amplitude Chrome extension Manage your Amplitude Data settings Data backfill
Plan your taxonomy Planning and instrumentation workflow Create a tracking plan Work with branches Ampli and developer tools Monitor your data with observe Protect your schema from unexpected data Integrate Jira with Amplitude Data
About user properties and event properties Event and property descriptions Event and property display names Event categorization Set an event's activity status Property types IP address and location properties Override a property definition Revert an overridden property definition Using property groups Cross-project analysis with Portfolios
Organize your tracking plan with Data Assistant Remove invalid or incorrect data Block bot web traffic Change the description of an event or property Fix your data with transformations Time to Live (TTL)
Custom events Object management Derived properties Lookup Tables Channels
Warehouse-native Amplitude: Overview Build a warehouse-native data model Warehouse-native Amplitude: Best Practices Warehouse Native Bulk Model Management
Amplitude Audiences overview
Sync to third-party destinations
Data
/
Amplitude Sources
/

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!

November 21st, 2024

Need help? Contact Support

Visit Amplitude.com

Have a look at the Amplitude Blog

Learn more at Amplitude Academy

Terms of Service Privacy Notice Acceptable Use Policy Legal

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