Define your data once.

-- customer_360.sql
-- Increment version → triggers review workflow in CI

CREATE OR REPLACE DATA PRODUCT customer_360
  VERSION 2
  DESCRIPTION 'Unified customer view: CRM + orders + support'
  OWNER 'data-platform@acme.com'
  TAGS ('certified', 'customer', 'pii-masked')
  REFRESH SCHEDULE '0 * * * *'          -- hourly

DATASET customers
  MATERIALIZED                               -- Iceberg MV for performance
  DESCRIPTION 'One row per customer, masked PII'
AS
  SELECT
    c.customer_id,
    c.name,
    sha256(c.email)           AS email_hash,
    COUNT(o.order_id)         AS total_orders,
    SUM(o.amount)             AS lifetime_value,    -- canonical definition
    c.segment,
    c.region,
    MAX(s.health_score)       AS support_health
  FROM      crm.customers  c
  LEFT JOIN orders.line_items o ON c.customer_id = o.customer_id
  LEFT JOIN support.scores   s ON c.customer_id = s.customer_id
  GROUP BY 1, 2, 3, 6, 7;