SELECT * with LIMIT to preview a table
Welcome aboard — give me a sanity check on the chart of accounts. Pull the first 10 rows of `dim_accounts` so I know the data loaded correctly. All columns.
| Column | Type | Key |
|---|---|---|
| account_id | INT | PK |
| account_code | TEXT | |
| account_name | TEXT | |
| account_type | TEXT | |
| is_active | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
The chart of accounts is in its own dimension table. To preview data without loading every row, think about how to cap the result at a small sample.
Add `LIMIT 10` so you don't fetch every row — there aren't many, but it's a habit worth building.
You need all columns from the accounts table — a star select is fine here — capped at 10 rows.