SELECT * with LIMIT to preview the core shipment fact table
Welcome to the logistics desk. Before we dive into OTD or cost analytics, I need you to get a feel for the shipment data. Pull the first 10 rows of `fact_shipments` — every column. I just want to see the row shape and understand what fields we're working with.
| Column | Type | Key |
|---|---|---|
| shipment_id | INT | PK |
| carrier_id | INT | FK → dim_carriers |
| lane_id | INT | FK → dim_lanes |
| planned_pickup_date | TEXT | |
| actual_pickup_date | TEXT | |
| planned_delivery_date | TEXT | |
| actual_delivery_date | TEXT | |
| qty_ordered | INT | |
| qty_shipped | INT | |
| weight_lbs | REAL | |
| freight_cost | REAL | |
| fuel_surcharge | REAL | |
| accessorial_cost | REAL | |
| dwell_hours_at_origin | REAL | |
| status | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
You can't pull a million-row table without a cap. Use the clause that limits rows returned.
LIMIT followed by an integer caps the result set at that number of rows.
The query reads from one table only — combine the projection clause and a row cap to cover both asks.