Amplitudelink
Amplitude is the comprehensive product analytics software for web and mobile.
Featureslink
| 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 guidelink
Follow our step-by-step Amplitude setup guide to connect Amplitude with your destination using Fivetran connectors.
Sync Overviewlink
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 informationlink
This schema applies to all Amplitude connectors.