{"id":9068,"date":"2026-09-16T11:31:04","date_gmt":"2026-09-16T11:31:04","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=9068"},"modified":"2026-09-17T05:30:38","modified_gmt":"2026-09-17T05:30:38","slug":"creation-and-deletion-of-bi-engine","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/creation-and-deletion-of-bi-engine\/","title":{"rendered":"Creation and deletion of BI Engine"},"content":{"rendered":"\r\n

BigQuery BI Engine: Creating and Deleting a Reservation<\/h1>\r\n

BigQuery<\/b><\/strong>\u00a0BI Engine is an in memory analysis service that accelerates queries, both from BigQuery SQL itself and from BI tools such as Looker Studio, down to sub second response times. It works by reserving a set amount of memory capacity that BigQuery uses to cache the data your queries touch most often.<\/p>\r\n

What a BI Engine Reservation Actually Costs<\/h2>\r\n

Reserved BI Engine capacity is billed at roughly 0.0416 US dollars per GiB per hour, and the first 100 GB of capacity is free. Past that, a reservation of an additional 50 GB runs in the neighborhood of 1,500 US dollars a month. Prices vary by region and change over time, so treat these as a starting point for budgeting rather than an exact quote, and always check the live cost estimate the console shows you before confirming.<\/p>\r\n

The detail that matters most here: this is billed by the hour for as long as the reservation exists, regardless of whether a single query actually runs against it. A reservation you create for a one time test and forget about will keep charging you every hour until you delete it.<\/p>\r\n

Step by Step Process of Creating and Deleting a Reservation<\/h2>\r\n

Step One: Open BI Engine<\/h3>\r\n

In the console, open the menu, then go to BigQuery, then BI Engine.<\/p>\r\n\r\n\r\n\r\n

Click Menu > Big Query > BI Engine.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Two: Create a Reservation<\/h3>\r\n\r\n\r\n\r\n
\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Three: Choose Location and Capacity<\/h3>\r\n

Choose the location for your reservation, and set the capacity you want to reserve. Click Next.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Four: Review the Estimated Cost<\/h3>\r\n

The right side of this screen shows the estimated cost for the capacity you have chosen. This is the number worth pausing on, since it reflects what you will be billed hourly for as long as this reservation exists, not a one time charge.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Five: Confirm Creation<\/h3>\r\n

Click Create.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

This will create the BI Engine.<\/p>\r\n\r\n\r\n\r\n

Deleting a BI Engine Reservation<\/h2>\r\n

To delete a reservation, click the three dots to the right of it in the list.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Click Delete.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Enter REMOVE to confirm deletion. Press proceed.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

The reservation will be deleted, and billing for it stops from that point on.<\/p>\r\n

BI Engine Compared to BigQuery Editions Slots<\/h2>\r\n

It is easy to mix these two up, since both involve reserving capacity in BigQuery. BigQuery Editions slot reservations reserve compute capacity for running your queries. BI Engine reservations, separately, reserve memory specifically for caching data so queries that hit that cached data run faster, closer to sub second response times. You can have one without the other, and many teams use plain on demand or Editions based query billing without ever touching BI Engine, since BI Engine is specifically for accelerating frequently repeated queries and dashboards, not for handling query volume in general.<\/p>\r\n

Common Mistakes to Avoid<\/h2>\r\n