SELECT * with LIMIT to preview a dimension table
Welcome to the team. Before we touch anything important, let's make sure the customer file loaded correctly. Pull the first 10 rows of `banking_customers` — all columns. I just want eyes on the shape of it.
| Column | Type | Key |
|---|---|---|
| customer_id | INT | PK |
| first_name | TEXT | |
| last_name | TEXT | |
| date_of_birth | TEXT | |
| state | TEXT | |
| onboarded_date | TEXT | |
| is_primary_only | INT |
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 at 10 rows.
Add `LIMIT 10` — always cap previews. A production customer table has millions of rows, and forgetting the LIMIT is the fastest way to lock up a dev database.
You need every column from banking_customers — a star select is fine here — capped at 10 rows.