Chapter 17 · Prompt Delta

Flight 05 Prompt Sequence

Copy this prompt and paste it into Codex.

Book
Draft 3.0
Prompt
1.0
Destination
Codex
Download plain text
Diagnose this data or ingestion problem inside the selected project and data boundary. Do not reingest, republish, alter schemas, delete files, or run unbounded queries yet.

Trace each input through upload, file validation, storage, metadata discovery, schema discovery, catalog or table creation, indexing or synchronization, status calculation, query resolution, and result presentation as applicable. Report item counts and state transitions at every observable stage.

For SQL failures, inspect the resolved tables and discovered columns, then validate names, types, joins, filters, aggregation, ordering, null behavior, and row-count boundaries. Use a small read-only probe instead of `SELECT *` when possible.

Identify the first stage where expected and actual counts or states diverge. Distinguish still running, timed out, partially successful, stale status, missing metadata, unsupported format, malformed input, permission failure, and application defect. Propose recovery that preserves already successful work.