Amplitude connector reference

Beta

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.

This page has reference information for the managed Amplitude connector, including supported source tables and destination table schemas.

Supported source tables

The Amplitude connector supports the following source tables, all under the default source schema:

Source table	Primary key	Description	Sync mode	Cursor field
events	uuid	Raw event stream exported from the Amplitude Export API.	Incremental	server_upload_time
events_list	id	Event types defined in the project.	Full refresh only
cohorts	id	Behavioral cohorts defined in the project.	Full refresh only
annotations	id	Chart annotations defined in the project.	Full refresh only

Source table	Primary key	Description	Sync mode	Cursor field
events	uuid	Raw event stream exported from the Amplitude Export API.	Incremental	server_upload_time
events_list	id	Event types defined in the project.	Full refresh only
cohorts	id	Behavioral cohorts defined in the project.	Full refresh only
annotations	id	Chart annotations defined in the project.	Full refresh only

Connector options

The following options tune ingestion for specific tables. For usage, see Examples.

Option	Type	Scope	Required	Applies to	Description
start_datetime	string	Table	No	events	Earliest event timestamp to ingest on the first sync, in yyyy-MM-dd'T'HH:mm:ss'Z' format. Defaults to 1970-01-01T00:00:00Z.
request_time_range	string	Table	No	events	Size of each export window, as an ISO-8601 duration. Defaults to PT24H. The minimum is PT2H.

Option	Type	Scope	Required	Applies to	Description
start_datetime	string	Table	No	events	Earliest event timestamp to ingest on the first sync, in yyyy-MM-dd'T'HH:mm:ss'Z' format. Defaults to 1970-01-01T00:00:00Z.
request_time_range	string	Table	No	events	Size of each export window, as an ISO-8601 duration. Defaults to PT24H. The minimum is PT2H.

Destination table schemas

events

Primary key: uuid Cursor field: server_upload_time

Field	Data type
uuid	STRING
id	BIGINT
device_id	STRING
user_id	STRING
amplitude_id	BIGINT
event_type	STRING
event_time	TIMESTAMP
client_event_time	TIMESTAMP
client_upload_time	TIMESTAMP
server_received_time	TIMESTAMP
server_upload_time	TIMESTAMP
processed_time	TIMESTAMP
session_id	BIGINT
event_properties	STRING
user_properties	STRING
group_properties	STRING
groups	STRING
event_id	BIGINT
amplitude_event_type	STRING
app	BIGINT
platform	STRING
os_name	STRING
os_version	STRING
device_brand	STRING
device_carrier	STRING
device_family	STRING
device_manufacturer	STRING
device_model	STRING
device_type	STRING
city	STRING
country	STRING
region	STRING
dma	STRING
language	STRING
library	STRING
ip_address	STRING
location_lat	DOUBLE
location_lng	DOUBLE
idfa	STRING
ad_id	STRING
paying	STRING
is_attribution_event	BOOLEAN
sample_rate	DOUBLE
schema	BIGINT
start_version	STRING
version_name	STRING
user_creation_time	TIMESTAMP
data	STRING
_insert_id	STRING

Field	Data type
uuid	STRING
id	BIGINT
device_id	STRING
user_id	STRING
amplitude_id	BIGINT
event_type	STRING
event_time	TIMESTAMP
client_event_time	TIMESTAMP
client_upload_time	TIMESTAMP
server_received_time	TIMESTAMP
server_upload_time	TIMESTAMP
processed_time	TIMESTAMP
session_id	BIGINT
event_properties	STRING
user_properties	STRING
group_properties	STRING
groups	STRING
event_id	BIGINT
amplitude_event_type	STRING
app	BIGINT
platform	STRING
os_name	STRING
os_version	STRING
device_brand	STRING
device_carrier	STRING
device_family	STRING
device_manufacturer	STRING
device_model	STRING
device_type	STRING
city	STRING
country	STRING
region	STRING
dma	STRING
language	STRING
library	STRING
ip_address	STRING
location_lat	DOUBLE
location_lng	DOUBLE
idfa	STRING
ad_id	STRING
paying	STRING
is_attribution_event	BOOLEAN
sample_rate	DOUBLE
schema	BIGINT
start_version	STRING
version_name	STRING
user_creation_time	TIMESTAMP
data	STRING
_insert_id	STRING

events_list

Primary key: id Sync mode: Full refresh only

Field	Data type
id	BIGINT
value	STRING
display	STRING
totals	BIGINT
totals_delta	BIGINT
non_active	BOOLEAN
deleted	BOOLEAN
hidden	BOOLEAN
flow_hidden	BOOLEAN
timeline_hidden	BOOLEAN
autohidden	BOOLEAN
in_waitroom	BOOLEAN
waitroom_approved	BOOLEAN
name	STRING

Field	Data type
id	BIGINT
value	STRING
display	STRING
totals	BIGINT
totals_delta	BIGINT
non_active	BOOLEAN
deleted	BOOLEAN
hidden	BOOLEAN
flow_hidden	BOOLEAN
timeline_hidden	BOOLEAN
autohidden	BOOLEAN
in_waitroom	BOOLEAN
waitroom_approved	BOOLEAN
name	STRING

cohorts

Primary key: id Sync mode: Full refresh only

Field	Data type
id	STRING
appId	BIGINT
name	STRING
description	STRING
size	BIGINT
owners	ARRAY<STRING>
viewers	ARRAY<STRING>
published	BOOLEAN
archived	BOOLEAN
is_predictive	BOOLEAN
type	STRING
definition	STRING
lastComputed	STRING
lastMod	BIGINT
createdAt	STRING
chart_id	STRING

Field	Data type
id	STRING
appId	BIGINT
name	STRING
description	STRING
size	BIGINT
owners	ARRAY<STRING>
viewers	ARRAY<STRING>
published	BOOLEAN
archived	BOOLEAN
is_predictive	BOOLEAN
type	STRING
definition	STRING
lastComputed	STRING
lastMod	BIGINT
createdAt	STRING
chart_id	STRING

annotations

Primary key: id Sync mode: Full refresh only

Field	Data type
id	BIGINT
start	STRING
end	STRING
label	STRING
details	STRING
chart_id	STRING
category	STRUCT<id: BIGINT, category: STRING>

Field	Data type
id	BIGINT
start	STRING
end	STRING
label	STRING
details	STRING
chart_id	STRING
category	STRUCT<id: BIGINT, category: STRING>