stg_postgres__chat_messages

staging view 1 PII columns

Chat messages, cleaned.

Definition

Chat messages authored by finance employees. `body_text` is free-text PII (nullify on erasure); the full body also lands in the GCS corpus at source_uri.

17 of 17

Column

Description

Tests · PII

chat_message_id

Primary key — UInt64.

employee PII2 tests

chat_channel_id

FK to `stg_postgres__chat_channels.chat_channel_id`. NOT NULL.

employee +1 PII2 tests

external_ref

client_msg_id (== corpus blob key). Unique.

2 tests

author_employee_id

FK to `stg_postgres__finance_employees.employee_id` (author). NOT NULL.

2 tests

posted_at

When the message was posted. DateTime64(6).

posted_day

Calendar date — toDate(posted_at).

thread_ts

Parent message ts; null for top-level. Nullable.

parent_message_id

Self-FK to the parent message. Nullable.

body_text

Message body. Free-text PII (nullify on erasure).

PII

is_edited

True if the message was edited.

reaction_count

Number of reactions. Int32.

source_uri

gs:// blob for the body. Nullable.

document_id

Corpus document_id, backfilled. Nullable.

document +5 PII

sha256

SHA-256 of the corpus blob, backfilled. Nullable.

source_created_at

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

source_updated_at

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

airbyte_extracted_at

When the loader extracted this row from postgres-source.