We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now
[Amplitude, Amplitude, is the comprehensive product analytics software for web and mobile., Features, Feature Name, Supported, Notes, Capture Deletes, check, EVENT_TYPE, table, Custom Data, check, EVENT, and , USER, tables, Data Blocking, check, USER, and its dependent tables only, Column Hashing, Re-sync, check, Connector level, History, API Configurable, check, Priority-first sync, check, All tables, dbt Package, Setup guide, Follow our , step-by-step Amplitude setup guide, to connect Amplitude with your destination using Fivetran connectors., Sync Overview, Fivetran syncs Amplitude data created on July 16, 2014 and later, because Amplitude changed the composition of the primary key on that date., The primary key for the , EVENT, table is composed of the parameters , id , device_id and , client_event_time, . Amplitude introduced the , client_event_time, parameter on July 16, 2014. Earlier events do not have the , client_event_time, parameter, which means we cannot form the primary key for them and thus cannot deduplicate the data. Other tables (except , EVENT_TYPE, ) depend on the , EVENT, table. Therefore, to maintain data integrity, we sync Amplitude data from July 16, 2014 onwards., Schema information, This schema applies to all Amplitude connectors., To zoom, open the ERD in a new window]
Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!