20260720 Corpus Explorer S1 Etl
Path:
loom-builder/prompts/20260720-corpus-explorer-s1-etl.mdRelative: prompts/20260720-corpus-explorer-s1-etl.mdSubproject: loom-builderCategory: dispatch-promptsLines: 134Bytes: 7,649Imports: 0Exports: 0
Content Preview
- # Corpus Explorer — S1 Data Plane (ETL → DuckDB → Parquet)
- ## User intent (restated)
- Mike wants his Claude conversation history (917 exported conversations, two
- accounts, already parsed to staging JSONL) turned into a queryable analytics
- dataset: a DuckDB database with proper tables, enrichment (categories/tags/
- languages), and a Parquet export the Astro site (S2, not your job) will read.
- **Success metric: all 12 spec §15 assertions pass green against the built
- DuckDB file, on the FULL corpus