20260720 Corpus Explorer S1 Etl

loom-builderpromptmarkdown
Path: loom-builder/prompts/20260720-corpus-explorer-s1-etl.mdRelative: prompts/20260720-corpus-explorer-s1-etl.mdSubproject: loom-builderCategory: dispatch-prompts
Lines: 134Bytes: 7,649Imports: 0Exports: 0

Content Preview

  1. # Corpus Explorer — S1 Data Plane (ETL → DuckDB → Parquet)
  2. ## User intent (restated)
  3. Mike wants his Claude conversation history (917 exported conversations, two
  4. accounts, already parsed to staging JSONL) turned into a queryable analytics
  5. dataset: a DuckDB database with proper tables, enrichment (categories/tags/
  6. languages), and a Parquet export the Astro site (S2, not your job) will read.
  7. **Success metric: all 12 spec §15 assertions pass green against the built
  8. DuckDB file, on the FULL corpus