---
title: Amplitude
description: Connect Amplitude, understand its sync behavior, and query every table and column it writes.
species: reference
---
# 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

1. Open **Apps**, choose **Connect app**, and select **Amplitude**.
2. Enter an API key, secret, and backfill start date.
3. Review the tables, then save the source.
4. 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](/v2/docs/concepts/your-lake#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.

```columns table=amplitude.events
uuid                                    string pk           Source field `uuid`.
event_id                                integer             Source field `event_id`.
event_type                              string              Source field `event_type`.
event_time                              datetime            Source field `event_time`.
user_id                                 string              Source field `user_id`.
session_id                              integer             Source field `session_id`.
amplitude_id                            integer             Source field `amplitude_id`.
amplitude_attribution_ids               string              Source field `amplitude_attribution_ids`.
server_received_time                    datetime            Source field `server_received_time`.
server_upload_time                      datetime            Source field `server_upload_time`.
client_upload_time                      datetime            Source field `client_upload_time`.
client_event_time                       datetime            Source field `client_event_time`.
sample_rate                             string              Source field `sample_rate`.
start_version                           string              Source field `start_version`.
app                                     integer             Source field `app`.
library                                 string              Source field `library`.
device_carrier                          string              Source field `device_carrier`.
processed_time                          datetime            Source field `processed_time`.
version_name                            string              Source field `version_name`.
paying                                  boolean             Source field `paying`.
platform                                string              Source field `platform`.
os_name                                 string              Source field `os_name`.
os_version                              string              Source field `os_version`.
device_id                               string              Source field `device_id`.
device_type                             string              Source field `device_type`.
device_family                           string              Source field `device_family`.
language                                string              Source field `language`.
country                                 string              Source field `country`.
region                                  string              Source field `region`.
city                                    string              Source field `city`.
dma                                     string              Source field `dma`.
ip_address                              string              Source field `ip_address`.
data                                    json                Source field `data`.
event_properties                        json                Source field `event_properties`.
user_properties                         json                Source field `user_properties`.
group_properties                        json                Source field `group_properties`.
groups                                  json                Source field `groups`.
location_lat                            float               Source field `location_lat`.
location_lng                            float               Source field `location_lng`.
insert_id                               string              Source field `insert_id`.
```

## Deletes and history

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets `_deleted` so queries can choose whether to include history. Filter current-state queries with `where not _deleted`.