stg_postgres__ticket_events

staging view 1 PII columns

Ticket lifecycle events, ready for rollup.

Definition

Per-ticket event stream typed and joined-ready. Adds `event_day = toDate(event_ts)` for daily rollups; comment payloads in `notes` are flagged as behavioral PII so column grants and erasure paths fire on them.

10 of 10

Column

Description

Tests · PII

ticket_event_id

Primary key — UInt64.

2 tests

ticket_id

FK to `stg_postgres__support_tickets.ticket_id`. NOT NULL.

customer PII2 tests

event_type

Event kind — `created`, `assigned`, `comment`, `status_change`, `csat_submitted`.

1 test

actor_type

Who emitted the event — `customer`, `agent`, or `system`.

actor_id

Customer or agent id depending on `actor_type`. Null for `system` events.

event_ts

Time the event happened. DateTime64(6).

event_day

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

notes

Free-text payload (comment body, status transition note, etc.). Nullable.

PII

source_created_at

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

airbyte_extracted_at

When Airbyte extracted this row from postgres-source.