Change theme
Help
Press space for more information.
Show links for this issue (Shortcut: i, l)
Copy issue ID
Previous Issue (Shortcut: k)
Next Issue (Shortcut: j)
Sign in to use full features.
Vote: I am impacted
Notification menu
Refresh (Shortcut: Shift+r)
Go home (Shortcut: u)
Pending code changes (auto-populated)
View issue level access limits(Press Alt + Right arrow for more information)
Unintended behavior
View staffing
Attachment actions
Description
In this secondary BigQuery management project, we have created a few explicit on-demand reservations covering a few folders, but they do not appear in the UI or when running the bq ls command[1]. It does the same when looking at both this and the other BigQuery management project.
We verified it was billing as on-demand via the JOBS view, but were not able to find this explicit creation in the UI or by the CLI.
Next, we added a fake reservation and refreshed the UI which showed it in the list then, per the attached screenshot. When attempting to look on the CLI it doesn't appear there at all either[2].
This appears to be a bug in the service where you cannot find on-demand projects if they were explicitly set that way if another reservation does not exist. It should show these in the list even if other reservations do not exist as they can be exceptions to a "catch-all" reservation in another project as we have shown. It would be ideal as well to show these from the CLI so you could know which projects were set to be on-demand explicitly.
[1]
<redacted>@cloudshell:~ (<project_id>)$ bq ls --reservation=true --project_id=<project_id>--location=us
No reservations found.
[2]<redacted>@cloudshell:~ (<project_id>)$ bq ls --reservation=true --project_id=<project_id> --location=us
name slotCapacity targetJobConcurrency ignoreIdleSlots creationTime updateTime multiRegionAuxiliary edition autoscaleMaxSlots autoscaleCurrentSlots
----------------------------------------------------------------- -------------- ---------------------- ----------------- ----------------------------- ----------------------------- ---------------------- ------------ ------------------- -----------------------
<project_id>:US.test 0 0 (auto) False 2024-11-27T18:34:41.001224Z 2024-11-27T18:34:41.001224Z False ENTERPRISE 50 0