Run a SELECT * with LIMIT to preview the shape of the orders fact table — order id, customer id, order number, financial status, fulfillment status, totals, channel, dates. The first thing every DTC analyst does on day one.
Welcome aboard. Before we touch any reports, let's just look at the orders file. Pull the first 10 rows of `ecom_orders` — all columns. I want eyes on the shape: what we record per order, what financial_status values look like, how channels and timestamps land. We'll come back to the question of which orders 'count' as revenue tomorrow.
| Column | Type | Key |
|---|---|---|
| order_id | INT | PK |
| customer_id | INT | FK → ecom_customers |
| order_number | TEXT | |
| financial_status | TEXT | |
| fulfillment_status | TEXT | |
| total_price | REAL | |
| subtotal | REAL | |
| tax | REAL | |
| shipping | REAL | |
| discount_total | REAL | |
| channel | TEXT | |
| created_date | TEXT | |
| processed_date | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
The orders table has 13 columns. The preview question is shape, not filter — so don't narrow the SELECT.
`SELECT * FROM ecom_orders LIMIT 10` is the entire query. One row per order.
Note that `processed_date` can be NULL — that's an unfulfilled / voided order signal. We'll filter on financial_status in mission 4.