Amplitude#

Connect Amplitude with an API key, secret, and backfill start date. The source writes 1 fixed table under titan.amplitude.

sql

select
  uuid,
  event_id,
  event_type
from titan.amplitude.events
limit 10

Connect Amplitude#

Open Apps, choose Connect app, and select Amplitude.
Enter an API key, secret, and backfill start date.
Review the tables, then save the source.
Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

The first run starts at your configured backfill date. Later runs continue from the last completed interval.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

`events`#

titan.amplitude.events has 40 source columns.

amplitude.events40 columns

uuidstringpk

Source field uuid.

event_idinteger

Source field event_id.

event_typestring

Source field event_type.

event_timedatetime

Source field event_time.

user_idstring

Source field user_id.

session_idinteger

Source field session_id.

amplitude_idinteger

Source field amplitude_id.

amplitude_attribution_idsstring

Source field amplitude_attribution_ids.

server_received_timedatetime

Source field server_received_time.

server_upload_timedatetime

Source field server_upload_time.

client_upload_timedatetime

Source field client_upload_time.

client_event_timedatetime

Source field client_event_time.

sample_ratestring

Source field sample_rate.

start_versionstring

Source field start_version.

appinteger

Source field app.

librarystring

Source field library.

device_carrierstring

Source field device_carrier.

processed_timedatetime

Source field processed_time.

version_namestring

Source field version_name.

payingboolean

Source field paying.

platformstring

Source field platform.

os_namestring

Source field os_name.

os_versionstring

Source field os_version.

device_idstring

Source field device_id.

device_typestring

Source field device_type.

device_familystring

Source field device_family.

languagestring

Source field language.

countrystring

Source field country.

regionstring

Source field region.

citystring

Source field city.

dmastring

Source field dma.

ip_addressstring

Source field ip_address.

datajson

Source field data.

event_propertiesjson

Source field event_properties.

user_propertiesjson

Source field user_properties.

group_propertiesjson

Source field group_properties.

groupsjson

Source field groups.

location_latfloat

Source field location_lat.

location_lngfloat

Source field location_lng.

insert_idstring

Source field insert_id.

Deletes and history#