int_orders__enriched

intermediate ephemeral

Orders, decorated with the customer behind them.

Definition

Ephemeral join — attaches customer country, segment, and signup date to each order, plus a derived `is_revenue_order` flag (`status not in (cancelled, refunded)`). Inlined into `mart_customers`, `mart_orders_daily`, and `mart_revenue_daily` so revenue-eligibility stays consistent across them.

11 of 11

Column

Description

Tests · PII

order_id

From `stg_postgres__orders.order_id`. Primary key.

customer +3 PII

customer_id

From `stg_postgres__orders.customer_id`.

customer +18 PII

customer_country

Country of the placing customer. Sourced from `stg_postgres__customers.country` via LEFT JOIN — nullable if the customer row is missing.

customer_segment

Sales segment of the placing customer. Sourced from `stg_postgres__customers.segment` via LEFT JOIN — nullable.

customer_signup_date

Signup date of the placing customer. Sourced from `stg_postgres__customers.signup_date` via LEFT JOIN — nullable.

order_at

Order placement timestamp.

order_day

Calendar date of `order_at`.

status

Order lifecycle state from staging.

currency

ISO-4217 currency code from staging.

total_amount

Order grand total from staging.

is_revenue_order

Derived — `status not in ('cancelled', 'refunded')`. Use this when computing revenue rollups so all marts share the same definition.