'BigQuery BI Engine is Missing US-Central1

The Docs for the BigQuery BI Engine say "BI Engine is supported in the same regions as BigQuery" (https://cloud.google.com/bigquery/docs/bi-engine-intro). Also I can see that in the release notes on 2021-01-19 that it says that both BigQuery and BI Engine are now available in us-central1 (Iowa) https://cloud.google.com/bigquery/docs/release-notes#January_19_2021

But when I go to make a reservation, it's not available in the region dropdown. Here are the US regions listed

  • US (multiple regions in United States)
  • us-west1 (Oregon)
  • us-west2 (Los Angeles)
  • us-west3 (Salt Lake City)
  • us-west4 (Las Vegas)
  • us-east1 (South Carolina)
  • us-east4 (Northern Virginia)

Is the any workaround?

I tried running this in the console:

bq update --reservation=true --bi_reservation_size=2 --location=us-central1 --project_id=<Project ID>

I get a response that looks like it went through, but when I go to check, it's not listed as a reservation, and when I view recent query jobs they say that BI Engine is disabled with the reason being there's no reservation.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source