SELECT * with LIMIT to preview a table
Welcome aboard. Before we touch any of the dashboards, let's make sure the customer file loaded correctly. Pull the first 10 rows of `retail_customers` — all columns. I just want eyes on the row shape.
| Column | Type | Key |
|---|---|---|
| customer_id | INT | PK |
| household_id | TEXT | |
| first_name | TEXT | |
| last_name | TEXT | |
| date_of_birth | TEXT | |
| state | TEXT | |
| segment | TEXT | |
| fico_current | INT | |
| estimated_income | REAL | |
| kyc_risk | TEXT | |
| acquisition_channel | TEXT | |
| onboarded_date | TEXT | |
| status | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
The customer table has hundreds of rows. To preview the data without fetching everything, think about how to cap the result.
Add `LIMIT 10` so you don't fetch every row — production customer tables have millions of rows and forgetting the cap is the fastest way to lock up a dev database.
You need every column from retail_customers — a star select is fine here — capped at 10 rows.