SELECT * with LIMIT to preview a fact table
Welcome to the team. Before we touch any forecast work, preview the `revops_opportunities` table. Pull the first 10 rows, all columns. This is the fact table at the center of every report you'll write here — knowing its shape cold is table stakes.
| Column | Type | Key |
|---|---|---|
| opportunity_id | INT | PK |
| account_id | INT | FK → revops_accounts |
| owner_user_id | INT | FK → revops_users |
| name | TEXT | |
| stage | TEXT | |
| amount | REAL | |
| close_date | TEXT | |
| created_date | TEXT | |
| is_closed | INT | |
| is_won | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
The `revops_opportunities` table is the fact table we'll anchor most queries around. A production table can have hundreds of thousands of rows — always cap previews.
Add `LIMIT 10` — always cap previews. Forgetting the LIMIT is how juniors accidentally pull 500K opportunity rows into the editor and lock up dev.
Full query: `SELECT * FROM revops_opportunities LIMIT 10`.