stg_postgres__events

staging view 2 PII columns

What customers did on the website, typed.

Definition

Web event log staged from the operational DB. Carries behavioral PII (`page_url` may embed query-string identifiers; `session_id` is an online identifier under GDPR Art. 4(1)). Short retention (90 days). Not yet consumed by a mart — staged so the source declaration is no longer dangling and an engagement-funnel mart can build on it.

10 of 10

Column

Description

Tests · PII

event_id

Primary key — UInt64.

2 tests

customer_id

FK to `stg_postgres__customers.customer_id`. Nullable for anonymous sessions.

customer +17 PII

event_type

Event kind — `page_view`, `add_to_cart`, `checkout_start`, `checkout_complete`.

1 test

event_at

Timestamp the event fired (renamed from `event_ts`). DateTime64(6).

1 test

event_day

Calendar date of the event — `toDate(event_at)`. Convenience for daily rollups.

1 test

page_url

Page where the event was emitted. May contain query-string identifiers — behavioral PII; excluded from AI personas via column grants.

PII

product_id

FK to `stg_postgres__products.product_id` when the event relates to a product. Nullable.

session_id

Opaque session identifier — joins events within a single browsing session. Online identifier under GDPR Art. 4(1).

PII

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When Airbyte extracted this row from postgres-source.