Order fact table with payment details
- File
- models/marts/orders.sql
Lineage
Upstream 2
- model stg_orders
- model stg_payments
Downstream 3
- model customers
- exposure how_are_sales_and_customers_developing
- exposure weekly_report
Tests 1
assert_orders_positive_amount
Columns 6
| Column | From | Used by |
|---|---|---|
| order_id | stg_orders.order_id | customers.order_count |
| customer_id | stg_orders.customer_id | |
| order_date | stg_orders.order_date | |
| status | stg_orders.status | |
| total_amount | stg_payments.amount | customers.lifetime_value |
| payment_method | stg_payments.payment_method |
SQL
SELECT
o.order_id,
o.customer_id,
o.order_date,
o.status,
p.amount as total_amount,
p.payment_method
FROM {{ ref('stg_orders') }} o
LEFT JOIN {{ ref('stg_payments') }} p ON o.order_id = p.order_id