Reservations details and limitations

This page describes BigQuery Reservations in detail, including permissions, commitment plans, and limitations. Before reading this page, consider reading Introduction to Reservations to understand the general concepts.

Permissions

By default, you can use bigquery.admin and project owner roles to manage BigQuery Reservations. These roles grant access to all BigQuery resources, including access to data and queries.

The following roles are available to use with BigQuery Reservations and do not grant access to data and queries. These roles can be granted at the organization, folder, or administration project level.

  • bigquery.resourceAdmin: allows purchasing and canceling commitments, modification of reservations, and modification of project-to-reservation assignments.

  • bigquery.resourceEditor: allows modification of reservations and project-to-reservation assignments, but does not allow purchasing or canceling commitments.

  • bigquery.resourceViewer: view all reservations and project-to-reservation assignments, but does not allow modification of these resources, or purchasing or canceling commitments.

Project-to-reservation assignment requires that you grant permission in both the administration project and the assignee projects. We recommend that you grant administrators the bigquery.resourceAdmin role at the organization or folder level.

For more information about granular BigQuery permissions, see roles and permissions.

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 bigqueryreservation.googleapis.com.

Enable API.

Commitment plans

BigQuery offers flex, monthly, and annual commitment plans. The minimum commitment size is 100 slots, and commitments are available in 100 slot increments, with no maximum. There is no limit on the number of commitments you can have.

You are charged per second from the moment your commitment purchase is successful. You can convert your commitment to a longer-duration commitment type at any time. See Converting commitments to longer-duration commitment types for more information

Commitments can be split into two. See Splitting commitments for more information. Multiple commitments of the same type can be merged into one. See Merging commitments for more information.

Purchased capacity commitments do not apply to non-analysis BigQuery costs (storage or streaming ingest). For information about BigQuery costs, see BigQuery pricing.

Flex Slots

  • You cannot cancel for 60 seconds after your commitment is active.
  • After 60 seconds, you can cancel at any time, and you will be charged only for the seconds your commitment was active.
  • For example:
    • If you purchase a commitment on 6:00:00 October 5th, you start being charged at that moment.
    • You cannot cancel until 6:01:00 October 5th.
    • If you cancel on 6:01:01 October 5th, you will be charged for 61 seconds (6:00:00 October 5th - 6:01:01 October 5th).
  • If you do not cancel, you continue to be charged.

Monthly commitments

  • You cannot cancel for 30 days after your commitment is active.
  • After 30 days, you can cancel at any time, and you will be charged only for the seconds your commitment was active.
  • For example:
    • If you purchase a commitment on 6:00:00 October 5th, you start being charged at that moment.
    • You cannot cancel until 6:00:00 November 4th.
    • If you cancel on 7:10:10 November 5th, you will be charged for 30 days plus one day, one hour, ten minutes, and ten seconds (6:00:00 October 5th - 7:10:10 November 5th).
  • If you do not cancel, you continue to be charged.

Annual commitments

  • You cannot cancel for 365 days after your commitment is active.
  • Prior to the commitment end date, you can choose to renew the annual commitment, or convert it to a monthly or flex commitment. For more information, see Renewing commitments.
  • The following options are available:
    • Renew for another year.
    • Decline to renew. Upon commitment end date, convert to a monthly commitment. You will be charged the monthly rate, and you will be able to cancel at any time.
    • Decline to renew. Upon commitment end date, convert to a flex commitment. You will be charged the flex slots rate, and you will be able to cancel at any time.
  • For example:
    • If you purchase a commitment on 6:00:00 October 5th 2019, you start being charged at that moment.
    • You cannot cancel or renew until 6:00:00 October 4th 2020 (2020 is a leap year).
    • If prior to 6:00:00 October 4th 2020 you choose to auto-renew, at 6:00:00 October 4th 2020 your commitment renews for another year.
    • If prior to 6:00:00 October 4th 2020 you choose to renew to a flex commitment, at 6:00:00:00 October 4th 2020 your commitment rolls over to a flex commitment, you are charged the flex slots rate, and you can cancel at any time.
    • If prior to 6:00:00 October 4th 2020 you choose to renew to a monthly commitment, at 6:00:00:00 October 4th 2020 your commitment rolls over to a monthly commitment, you are charged the monthly commitment rate, and you cannot cancel for 30 days.

Trial Slots

On May 20, 2020, BigQuery introduced a limited promotion for new or returning BigQuery customers. Qualified customers can purchase Trial slots, which is a 500 slot, 6-month commitment at a deeply discounted rate. For more information, see Trial slots pricing.

  • You cannot cancel for 182 days after your commitment is active.
  • After 182 days, your commitment will be converted to flex slots, you will be able to cancel at any time, and you will be charged only for the seconds your commitment was active. You will start getting charged flex slots rates.
  • For example:
    • If you purchase a commitment on 6:00:00 October 5th, 2020, you start being charged at that moment.
    • You cannot cancel until 6:00:00 April 5th, 2021
    • On 6:00:00 April 5th, 2021, your commitment will be converted to flex slots, you are charged the flex slots rates, and you can cancel at any time.

Renewing commitments

For annual commitments, before the commitment end date, you can choose what happens to the commitment after the commitment ends. You can:

  • Renew for another year.
  • Decline to renew. Upon commitment end date, convert to a monthly commitment. You will be charged the monthly rate, and you will be able to cancel at any time.
  • Decline to renew. Upon commitment end date, convert to a flex commitment. You will be charged the flex slots rate, and you will be able to cancel at any time.

For more information about how to choose your renewal option, see Renew a commitment.

Canceling commitments

After you create a commitment, it is not possible to cancel it until the commitment end time.

If you accidentally purchased a commitment or made a mistake when you configured your commitment, contact Cloud Billing Support for help.

Limitations

  • 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.
  • Commitments are a regional resource. Commitments purchased in one region cannot be used in any other regions, and commitments cannot be moved between regions.

Quotas

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.

You cannot purchase more capacity than is allowed by your quota. To raise your quota limit, select the Edit Quotas button in the Cloud Console and request a quota increase for the total number of slots in the desired region.

Reservations quota.