SELECT * with LIMIT to preview a dimension table
Welcome to the team. Before we touch any rules, let's make sure the customer file loaded. Pull the first 10 rows of `aml_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 | |
| TEXT | ||
| phone | TEXT | |
| state | TEXT | |
| status | TEXT | |
| onboarded_date | TEXT | |
| last_kyc_refresh | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
The customer table has hundreds of rows. To preview without fetching everything, think about how to cap the result at 10.
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 aml_customers — a star select is fine here — capped at 10 rows.