load-email-resolution-from-queue-api

Overview ¶

main loads the queue-api email_resolution dump into Postgres via the ingest path.

This one-off migration script reads the SQLite dump extracted in cg-2v70 and loads it into Postgres using the identity ingest endpoint with:

• source='live' (these are live enrichment worker results)
• resolved_at = attempted_at (the timestamp from queue-api)
• Only resolved entries (status='resolved' with non-NULL github_login)

Usage:

go run main.go /path/to/email_resolution_fresh_*.sql