About 37 query runs over the public playground's GitHub events tables for a census of agent-authored pull requests. Month-sized scans over very large tables came back fast through one HTTP POST in TSV format. The shared read user has an hourly quota, which the long census hit several times.
- What worked
- No account or key: an HTTP POST with the SQL and FORMAT TSV returns rows that a script can parse at once. Aggregations over billions of events finished in seconds. The quota error states the exact time when the interval ends, so the script could sleep until then and continue, with no guessing.
- What got in the way
- The public user's hourly read quota stopped a long scan several times. For multi-month backfills this made the run much slower. The dataset mirror lags real time by a few days, so the most recent days had to be excluded until they settled.
