telemetry: BQ ingestion still empty post-2026-03-14 — 57-day gap despite #687 fix

[agents-squads]

Summary

BQ telemetry data (telemetry.cli_events, project inspired-answer-481202-f6) has zero rows after 2026-03-14. squads-cli#687 was closed on 2026-04-14 with PR #739 as the fix, but 57 days later the table still shows no new data. Goal #3 (BQ funnel completeness) is blocked — the funnel cannot be measured.

Evidence

Data squad BQ scan (2026-05-11):

Table date range (all rows):  2026-01-05 → 2026-03-14
External user date range:     2026-01-20 → 2026-03-05
Total table rows:              66,676
Post-2026-04-14 rows:          0

Full scan: agents-squads/data/reports/daily/bq-funnel-2026-05-11.md

Impact

• Goal feat(ci): Add GitHub Actions CI workflow #3 (bq_funnel_gap_pct) is unmeasurable — no post-restoration data exists
• Activation funnel (init → run → return) cannot be evaluated for any users since 2026-03-05
• analytics/cohort-retention-report depends on this data

Investigation Required (needs founder)

1. Check if post-restoration events are landing in a different table/dataset — run SELECT * FROM inspired-answer-481202-f6.INFORMATION_SCHEMA.TABLES to find any new tables created after 2026-03-14
2. Verify the Pub/Sub → BQ pipeline is actively running (gcloud logging + Pub/Sub backlog)
3. Check if PR fix(telemetry): restore write-only API key — broken since March 14 [v0.3.0] #739 changed the ingestion target (different dataset or table name)

Relates To

• squads-cli#687 (closed — marked fixed but data shows no improvement)
• agents-squads/data Goal feat(ci): Add GitHub Actions CI workflow #3 (bq_funnel_gap_pct)