Staged payments data
- File
- models/staging/stg_payments.sql
Lineage
Upstream 1
- source raw.payments
Downstream 2
- model orders
- exposure which_payment_methods_do_customers_use
Columns 4
| Column | From | Used by |
|---|---|---|
| payment_id | raw.payments.id, raw.payments.payment_id | |
| order_id | raw.payments.order_id | |
| amount | raw.payments.amount | orders.total_amount |
| payment_method | raw.payments.payment_method | orders.payment_method |
SQL
SELECT
id as payment_id,
order_id,
amount,
payment_method
FROM {{ source('raw', 'payments') }}