stg_postgres__addresses

staging view 6 PII columns

Addresses, typed and country-normalised.

Definition

Customer shipping/billing addresses staged for join with `stg_postgres__shipments`. `valid_from` / `valid_to` form the SCD-2 validity window so the resolver can isolate address history per customer; the address lines (`line1`, `line2`), `city`, `region`, `postal_code`, and `country` are tagged as location-PII so column grants strip them for AI personas.

15 of 15

Column

Description

Tests · PII

address_id

Primary key — UInt64.

2 tests

customer_id

FK to `stg_postgres__customers.customer_id`. NOT NULL.

customer +17 PII2 tests

address_type

`shipping` or `billing`.

1 test

line1

Street address line 1.

PII

line2

Street address line 2 (suite, apt). Nullable.

PII

city

City of residence.

PII

region

State / province. Nullable for countries without subdivisions.

PII

postal_code

Postal / ZIP code.

PII

country

ISO-2 country code, upper-cased. Drives cross-border / data-residency analysis.

PII

is_default

True for the customer's default address per type.

valid_from

Start of validity window. DateTime64(6).

1 test

valid_to

End of validity window. Nullable = currently valid.

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 Airbyte extracted this row from postgres-source.