Understand BigQuery editions

BigQuery provides three editions which support different types of workloads and the features associated with them. You can enable editions when you reserve BigQuery capacity . BigQuery also provides an on-demand (per TiB processed) model . You can choose to use editions and the on-demand model at the same time on a per-project basis. For more information about BigQuery editions pricing, see BigQuery pricing .

Each edition provides a set of capabilities at a different price point to meet the requirements of different types of organizations. You can create a reservation or a capacity commitment associated with an edition. Reservations configured to use slots autoscaling automatically scale to accommodate the demands of their workloads. Capacity commitments are not required to purchase slots, but can reduce costs. Because BigQuery editions are a property of compute power, not storage, you can query datasets regardless of how they are stored provided your edition supports the capabilities that you want to use. Slots from all editions are subject to the same quota. Your quota is not fulfilled on a per-edition basis. For more information about quotas, see Quotas and limits .

BigQuery editions features

The following tables lists the features available in each edition. Features outside of your edition are blocked or lack capabilities.

Don't use edition tiers to restrict access to specific features, because the features assigned to each edition can change over time. For example, don't assign projects to Standard edition reservations as a way of disallowing access to BigQuery ML.

Administration features

Analysis features

What's next

• For more information on slots autoscaling, see Introduction to slots autoscaling .
• For more information on reservations, see Introduction to Reservations .