BigQuery Reservations enables you to do the following:
- Switch from the on-demand pricing model to flat-rate pricing, or combine the two models.
- Purchase and deploy dedicated BigQuery slots for analysis.
- Allocate BigQuery slots across your entire organization for workload management.
BigQuery offers a choice between two pricing models for analytics:
- On-demand pricing: You pay only for the data scanned by your queries.
- Flat-rate pricing: Offers predictable and consistent month-to-month costs.
By default, you are billed according to the on-demand pricing model. With BigQuery Reservations, you can optionally switch to the flat-rate pricing model by purchasing commitments, which are dedicated portions of query processing capacity that are measured in BigQuery slots. The cost of all bytes processed is included in the monthly flat-rate price.
- Flat-rate pricing: You pay a stable monthly cost for analysis rather than paying the on-demand price per TB of data processed. For more information, see BigQuery pricing.
- Flexible pricing: Provides mix-and-match flat-rate and on-demand pricing within an organization. Customers can run on-demand for one workload and flat-rate for another.
- Workload management: You allocate slots to workloads for workload isolation and prioritization.
- Efficiency: Any unused slots are seamlessly and immediately shared across the entire organization.
- Organization-scoped: You can purchase and allocate slots for your entire organization. There is no need to purchase slots for each project in which you use BigQuery.
BigQuery Reservations introduces three key concepts:
- You can purchase dedicated BigQuery slots by procuring commitments.
- Optionally, you can partition and isolate your committed BigQuery slots to reservations for workload management purposes.
- Use assignments to assign Google Cloud projects, folders, or your entire organization to reservations.
Purchasing commitments, modifying reservations, and modifying
project-to-reservation assignments requires IAM permissions that are part of the
For more information about granular BigQuery permissions, see roles and permissions.
Choosing an Administration Project
BigQuery Reservations help you securely manage your entire Google Cloud organization's BigQuery resources centrally. This is done by picking a single Google Cloud project as your administration project.
We recommend that you elect an administration project by only enabling the BigQuery Reservations API on a single project.
The administration project creates and maintains ownership of BigQuery Reservations resources (commitments, reservations, and assignments). BigQuery Reservations resources can then be shared out to all the other projects in the organization by using assignments. Google recommends that you create a new project with a descriptive name.
Any project using a reservation owned by the admin project isn't billed for analysis (that is, running queries) but continues to be separately billed for storage. All BigQuery Reservations commitments made in the administration project are billed to the administration project.
Enabling the Reservations API
The BigQuery Reservation API is distinct from the existing BigQuery API and must be enabled independently. For more information, see Enabling and disabling APIs.
- The name of the API is "BigQuery Reservations API"
- The endpoint for the BigQuery Reservation API is
Quota is the maximum allowable number of BigQuery slots you can purchase in the UI. You are not billed for quotas; you are only billed for purchased commitments. Quotas are defined per-region.
If you attempt to purchase more capacity than allowed by your quota, you receive an error. To raise your quota limit, contact support.
You can view your current BigQuery Reservation API quotas and limits using the Cloud Console.
- During beta, you must have a Google Cloud organization.
- Reservations that you buy cannot be shared with other organizations.
- You must create a separate reservation and a separate administration project for each organization.
- There is no sharing of idle capacity between organizations.
During the beta period, the BigQuery Reservation API is currently accessible only in the following locations: