Staged orders data
- File
- models/staging/stg_orders.sql
Lineage
Upstream 1
- source raw.orders
Downstream 1
- model orders
Columns 4
| Column | From | Used by |
|---|---|---|
| order_id | raw.orders.id, raw.orders.order_id | orders.order_id |
| customer_id | raw.orders.user_id, raw.orders.customer_id | orders.customer_id |
| order_date | raw.orders.order_date | orders.order_date |
| status | raw.orders.status | orders.status |
SQL
SELECT
id as order_id,
user_id as customer_id,
order_date,
status
FROM {{ source('raw', 'orders') }}