Fivetran documentation

Search the docs

/

Amplitude

Explore the interactive ERD

Table & Field Reference

event

Column	Type	Keys
`device_id`	String	PK
`id`	Long	PK
`server_upload_time`	Instant	PK
`event_type_id`	Long	FK
`_insert_id`	String
`ad_id`	String
`amplitude_event_type`	String
`amplitude_id`	Long
`app`	String
`city`	String
`client_event_time`	Instant
`client_upload_time`	Instant
`country`	String
`data`	Json
`device_brand`	String
`device_carrier`	String
`device_family`	String
`device_manufacturer`	String
`device_model`	String
`device_type`	String
`dma`	String
`event_properties`	Json
`event_time`	Instant
`event_type`	String
`group_properties`	Json
`groups`	Json
`idfa`	String
`ip_address`	String
`is_attribution_event`	Boolean
`language`	String
`library`	String
`location_lat`	String
`location_lng`	String
`os_name`	String
`os_version`	String
`paying`	Boolean
`platform`	String
`processed_time`	Instant
`project_name`	String
`region`	String
`sample_rate`	Int
`schema`	Int
`server_received_time`	Instant
`session_id`	Long
`start_version`	String
`user_creation_time`	Instant
`user_id`	String
`user_properties`	Json
`uuid`	String
`version_name`	String

event_type

Column	Type	Keys
`id`	Long	PK
`project_name`	String	PK
`autohidden`	Boolean
`deleted`	Boolean
`display`	String
`flow_hidden`	Boolean
`hidden`	Boolean
`in_waitroom`	Boolean
`name`	String
`non_active`	Boolean
`timeline_hidden`	Boolean
`totals`	Int
`totals_delta`	Long
`value`	String
`waitroom_approved`	String

event_amplitude_attribution_id

Column	Type	Keys
`amplitude_attribution_id`	String	PK
`device_id`	String	PKFK
`event_id`	Long	PKFK
`server_upload_time`	Instant	PKFK
`client_event_time`	Instant