Data — Overview

Stub. This section will hold schema documentation for both the operational data layer (Postgres) and the analytics layer (Athena).

Operational data

RDS Postgres (with a small slice in RDS Aurora for IP lookup). Multiple schemas — the Alyson product schema and others. See the Backend service doc and ADR-0003 (TBD) for the multi-schema clutter context.

To be documented per schema and per table.

Analytics data

AWS Athena. Layered as raw.*, optimized.*, unified.*. Key tables include:

• raw.raw_tune_clicks / unified.uct_events (connector_id=1) — TUNE clicks
• raw.segment_events / unified.uct_events (connector_id=4) — Segment events
• sampled.revenue_leads_plus — HomeLight raw
• unified.uct_leads, unified.uct_revenue — unified leads & revenue
• raw.ip2locations_data — IP metadata
• unified.dim_offer, unified.dimension_vendors — offer/vendor dimensions

Each will get its own page with schema, semantics, joining keys, gotchas (e.g. duplicate transaction_ids for bot traffic).