Amplitude
Amplitude is the comprehensive product analytics software for web and mobile.
Supported services
You can send events directly to your destination from your Amplitude account using Amplitude API or host them in an Amazon S3 or Google Cloud using the Amplitude Cloud Storage Export feature, and connect your bucket with Fivetran to sync your Amplitude data to your destination.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | EVENT_TYPE table |
| History mode | ||
| Custom data | check | EVENT table |
| Data blocking | check | EVENT_AMPLITUDE_ATTRIBUTION_ID table |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
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 May 1, 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 server_upload_time. Amplitude introduced the server_upload_time parameter on May 1, 2014. Earlier events do not have the server_upload_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 May 1, 2014 onwards.
Schema information
This schema applies to all Amplitude connectors.
To zoom, open the ERD in a new window.