stg_gcs__whse_consignees

staging view 6 PII columns

B2C recipients, typed — the primary DSR subject.

Definition

Cleaned mirror of `raw_gcs.whse_consignees`. Coerces the CSV's `Nullable(String)` columns into typed equivalents. Carries identity (full_name), contact (email/phone), and location (address_line/city/postal_code) PII keyed to `consignee_id`, all tagged so masking + erasure fire end-to-end. Never surfaces raw via the AI layer. `country` is coarse and not PII on its own.

13 of 13

Column

Description

Tests · PII

consignee_id

UUID5 from the source CSV. Primary key.

consignee PII3 tests

full_name

Consignee full name. Identity PII.

PII

Consignee email address. Contact PII.

PII

phone

Consignee phone number. Contact PII.

PII

address_line

Consignee street address. Location PII.

PII

city

Consignee city. Location PII.

PII

postal_code

Consignee postal code. Location PII.

PII

country

ISO-3166 alpha-2 country. Coarse — not PII on its own.

1 test

consignee_type

Recipient type — B2C vs B2B2B drop.

2 tests

created_at

UTC timestamp the consignee record was created. Parsed from String → DateTime64(3).

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.