We have discovered an issue with the Reservation UI and CLI, which we assume comes from the API itself on reporting reservation information. We have a "catch-all" reservation set up in one project that is assigned to the entire organization to cover newly created projects, but we also have another BigQuery management project with very specific IAM assignments for some users to create reservations as needed for testing purposes.

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