Reserving BI Engine capacity

When you use BigQuery BI Engine, your charges are based on the BI Engine capacity you purchased for your project. There are two ways to purchase BI Engine capacity:

• Purchasing capacity on-demand
• Bundling BI Engine capacity when you enroll in BigQuery flat-rate pricing

You purchase BI Engine capacity by creating a reservation. The reservation is attached to a project you identify when the reservation is created. BI Engine uses this capacity to determine how much data can be cached. For more information about the maximum reservation size for BI Engine, see Quotas and limits.

Reservation project: BI Engine reservations are managed by the billing project's ID. When purchasing a reservation, ensure that you specify the billing project ID that you intend to use to query your data, which is not necessarily the project that contains the dataset.

Create a reservation

To reserve on-demand BI Engine capacity:

1. In the Google Cloud console, under Administration go to the BI Engine page.

   Go to the BI Engine page

   Note: If prompted to enable BigQuery Reservation API, click Enable.

2. Click Create reservation.

3. On the Create reservation page, for Step 1:

   • Verify your project name.
   • Choose your location. The location should match the location of the datasets you are querying.

   • Adjust the slider to the amount of memory capacity you're reserving. The following example sets the capacity to 2 GB. The current maximum is 250 GB.

     

4. Click Next.

5. For Step 2, review your reservation details, and then click Create.

After you confirm your reservation, the details are displayed on the Reservations page.

Delete a reservation

To delete a capacity reservation:

1. In the Google Cloud console, under Administration go to the BI Engine page.

   Go to the BI Engine page

   Note: If prompted to enable BigQuery Reservation API, click Enable.

2. In the Reservations section, locate your reservation.

3. In the Actions column, click the icon to the right of your reservation and choose Delete.

4. In the Confirm reservation removal dialog, enter REMOVE and then click Proceed.

When you delete all capacity reservations in a project, BI Engine is disabled for that project.

View resource metadata

You can get information about your BI Engine capacity by querying the INFORMATION_SCHEMA tables. BigQuery provides the following INFORMATION_SCHEMA views:

• INFORMATION_SCHEMA.BI_CAPACITIES contains metadata about the current state of BI Engine capacity.
• INFORMATION_SCHEMA.BI_CAPACITY_CHANGES contains history of changes to the BI Engine capacity.

What's next

• For an overview of BigQuery BI Engine, see Introduction to BigQuery BI Engine.
• Learn more about BigQuery BI Engine Pricing.
• Get started with BI Engine.