maiven gateway · online··
manifest · 2d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_postgres__customers

staging view 3 PII columns

Customers, cleaned for MergeTree.

Lineage Builds PII registry
Definition

Customers staged from the operational DB — Airbyte's `Nullable(...)` wrapper stripped on PK and date columns so MergeTree marts can use them as keys, email lower-cased and trimmed, country normalised to ISO-2 uppercase. The canonical customer dimension feeding every customer-keyed mart.

10 of 10
Column
Description
Tests · PII
customer_id
Primary key — UInt64. Matches `raw_postgres.customers.customer_id`.
customer +17 PII12 tests
email
Lower-cased, trimmed customer email. Treated as PII downstream.
1 testPII
first_name
Customer first name, passed through unchanged. Nullable.
PII
last_name
Customer last name, passed through unchanged. Nullable.
PII
country
ISO-2 country code, upper-cased.
segment
Customer segment — `consumer`, `business`, or `enterprise`.
1 test
signup_date
Date the customer first registered. NOT NULL — used as a partition / filter key downstream.
1 test
source_created_at
Row insert timestamp from the source DB (`customers.created_at`). DateTime64(6).
source_updated_at
Row update timestamp from the source DB (`customers.updated_at`). DateTime64(6).
airbyte_extracted_at
When Airbyte extracted this row from postgres-source. Drives source-freshness checks.