CONNECTOR · AMPLITUDE

Amplitude — Event analytics. We pull the raw export and rebuild funnels in dbt.

CONNECTOR · AMPLITUDE

Amplitude

Event analytics. We pull the raw export and rebuild funnels in dbt.

categorySource · Product analytics
freshness targetHourly via S3 / GCS export.
auth modelAPI key + secret per project.
sync modeCompressed JSONL export → staging → dbt.

TABLES SYNCED

events, user_properties, sessions.

SCHEMA · SAMPLE

schema.sqlSQL

CREATE TABLE amplitude.events (
  event_type      TEXT,
  user_id         TEXT,
  device_id       TEXT,
  event_time      TIMESTAMP,
  event_properties JSONB
);

QUERY · SAMPLE

query.sqlSQL

SELECT event_type, COUNT(*) AS n
FROM amplitude.events
WHERE event_time >= now() - interval 0
GROUP BY 1 ORDER BY 2 DESC LIMIT 25;

OPS NOTES

user_id ↔ device_id stitching is the same problem as Segment's. Test it deterministically on every PR.

RELATED · CONNECTORS

Source · OLTP

Postgres

Destination · Warehouse

Snowflake

Destination · Warehouse

BigQuery

Source · Event tracking

Segment

Wire a real pipeline to your warehouse

30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.

Book a 30-min review Open the playground