01
Complete
Local Foundations and Batch Ingestion
Learned how to extract OpenAQ data, save raw JSON, transform API payloads into curated rows, validate fields, load SQLite, and serve a dashboard.
This page is the single browser home for the tasks you have learned so far. Each task has its own goal, code, SQL, tests, and visual guide so you can trace it later.
Learned how to extract OpenAQ data, save raw JSON, transform API payloads into curated rows, validate fields, load SQLite, and serve a dashboard.
Learned what was new after ingestion: dimensions, facts, table grain, keys, joins, foreign-key constraints, indexes, and idempotent mart refreshes.
data/raw/*.jsonair_quality_measurementsdim_* and fact_*| When You Want To | Open |
|---|---|
| Review what you learned in a task | The task visual guide |
| Replay the task from terminal commands | The task markdown guide |
| Practice SQL for the task | The task SQL workbook |
| See the cumulative application | http://localhost:8501 |