stg_gcs__rfx_contacts

staging view 3 PII columns

Buyer-side contacts, typed and FK-validated.

Definition

Cleaned mirror of `raw_gcs.rfx_contacts`. Coerces the CSV's `Nullable(String)` columns into typed equivalents and enforces the FK to `stg_gcs__rfx_accounts` so an unknown account fails tests instead of landing silently. The name/email/phone columns are tagged PII so masking + erasure fire end-to-end.

11 of 11

Column

Description

Tests · PII

contact_id

UUID5 from the source CSV. Primary key.

procurement_contact +1 PII2 tests

account_id

Foreign key to stg_gcs__rfx_accounts. Nulls are kept so the `relationships` test surfaces bad rows.

2 tests

full_name

Contact full name. Identity PII.

PII

title

Job title at the buying organisation. Free-text, not PII on its own.

Contact email address. Contact PII.

PII

phone

Contact phone number. Contact PII.

PII

is_primary

1 for the account's primary contact, 0 otherwise. Coerced from the CSV's "true"/"false" strings.

2 tests

created_at

UTC timestamp the contact record was created. Parsed from the CSV's ISO-8601 string.

1 test

source_file_url

Airbyte-supplied `_ab_source_file_url` — the gs:// URI the row came from.

source_file_modified_at

Airbyte-supplied `_ab_source_file_last_modified` — object mtime of the source file.

airbyte_extracted_at

When Airbyte extracted this row from GCS.