Stay organized with collections Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-05-05 UTC."],[[["BigQuery offers three editions (Standard, Enterprise, and Enterprise Plus) and an on-demand pricing model to accommodate various workload types and feature needs, which you can enable when you reserve capacity."],["Each BigQuery edition provides a unique set of features and capabilities at different price points, such as compliance controls, BI acceleration, workload management, and more, allowing organizations to choose the most suitable option for their needs."],["BigQuery editions determine compute power and available features, but datasets can be queried regardless of storage methods, as long as the chosen edition supports the desired capabilities, where each edition has specific admin control features."],["Features assigned to each edition can change over time, so using edition tiers to manage feature access is not recommended, and you should not assign projects to Standard editions to restrict access to certain features."],["Enterprise and Enterprise Plus editions allow for customer-managed encryption keys, while Standard edition only offers Google-managed encryption keys, and they all have different access to different features."]]],[]]
