beginner · self-paced
Warehouse Introduction for App Devs
5 weeks · 4–6 hrs/week
Learn star schema basics, incremental loads at a conceptual level, and how to write app events analysts can consume. Designed for application engineers partnering with a warehouse team.
What ships in this outline
- Star vs snowflake sketches
- Event naming workshop
- Late-arriving data scenario
- SLA language for handoffs
- Office hours with a practicing analytics engineer
Outcomes
- Propose event fields that survive downstream joins
- Read a simple dbt model and spot a grain mistake
- Write a crisp question for your analytics partner
Lead mentor
Lin Okada
SRE turned database mentor; previously owned incident reviews for query regressions.
FAQ
Intermediate SELECTs; window functions introduced gently.
Concepts apply; we do not bill your Snowflake/BigQuery.
Streaming exactly-once frameworks are named only.
Experience notes
“Finally stopped arguing about event names blindly. Grain mistake exercise saved a sprint.”