One customer.One governed view.

CREATE VIEW analytics.customer_360 AS
SELECT
    c.customer_id,
    c.email,                           -- pii.masked
    c.full_name,                       -- pii.masked
    c.country,
    SUM(i.amount)              AS lifetime_value,
    MAX(i.paid_at)             AS last_payment_at,
    COUNT(DISTINCT s.session_id) AS sessions_30d,
    MAX(s.last_seen_at)        AS last_seen_at
FROM postgres.crm.customers       c
LEFT JOIN oracle.billing.invoices i USING (customer_id)
LEFT JOIN mongo.events.sessions   s
       ON s.customer_id = c.customer_id
      AND s.last_seen_at > now() - interval '30 days'
GROUP BY 1, 2, 3, 4
WITH POLICY pii_masked, audit_all, rbac_per_role
PUBLISH ON sql, rest, mcp;