maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Email messages with inline `body_text` (full body also lands in the GCS corpus at source_uri; document_id/sha256 backfilled). subject / body_text / sender_email / sender_display_name are PII (nullify on erasure). 365-day comms retention.
23 of 23
Column
Description
Tests · PII
email_thread_id
FK to `stg_postgres__email_threads.email_thread_id`. NOT NULL.
2 tests
external_ref
RFC822 Message-ID (== corpus blob key). Unique.
2 tests
direction
Direction relative to the mailbox owner — inbound / outbound.
1 test
sender_employee_id
FK to `stg_postgres__finance_employees.employee_id` when sender is internal. Nullable.
sender_party_type
Sender party — employee / customer / vendor / external_other.
1 test
sender_customer_id
FK to ecommerce `stg_postgres__customers.customer_id` when sender is a customer. Nullable.
sender_vendor_id
FK to `stg_postgres__vendors.vendor_id` when sender is a vendor. Nullable.
sender_email
Lowercased sender email. Contact PII.
PII
sender_display_name
Sender display name. Contact PII. Nullable.
PII
subject
Message subject. Free-text PII.
PII
body_text
Inline searchable message body. Free-text PII (nullify on erasure).
PII
body_format
Body format — text / html_stripped.
1 test
sent_at
When the message was sent. DateTime64(6).
sent_day
Calendar date — toDate(sent_at).
has_attachments
True when the message carried attachments.
in_reply_to_message_id
Self-FK to the message this replies to. Nullable.
source_uri
gs:// blob for the full body. Nullable.
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.