SELECT * with LIMIT to preview a HMDA-shaped application table
Welcome to the credit floor. Before we touch any HMDA submissions or vintage curves, I need eyes on the application file. Pull the first 10 rows of `lending_applications` — all columns. I just want a feel for the row shape and what fields the LAR generator hands us.
| Column | Type | Key |
|---|---|---|
| app_id | INT | PK |
| customer_id | INT | FK → retail_customers |
| product_id | INT | FK → retail_products |
| application_date | TEXT | |
| requested_amount | REAL | |
| requested_term | INT | |
| loan_purpose | TEXT | |
| action_taken | INT | |
| denial_reason_1 | INT | |
| aus_recommendation | TEXT | |
| rate_spread | REAL | |
| lien_status | INT | |
| occupancy | INT | |
| ethnicity | INT | |
| race | INT | |
| sex | INT | |
| age_bucket | TEXT | |
| property_tract | TEXT | FK → lending_geography |
Each hint you reveal reduces the XP you can earn. Try the query first.
Production HMDA tables run into millions of rows — you can't preview them by fetching everything. Reach for the row-cap clause in your SQL dialect.
The cap is the last clause in the SELECT. It takes one integer — the row count the briefing asked for.
Marcus wants a feel for the whole row shape, so the projection should be every column, not a hand-picked subset. Pair the star projection with the cap.