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.
Access to core features for building data driven experiences through Gemini Code Assist. No access for system optimization and administrator productivity features.
Access to core features for building data driven experiences through Gemini Code Assist. No access for system optimization and administrator productivity features.
Access to all Gemini in BigQuery features.
Access to core features for building data driven experiences through Gemini Code Assist. No access for system optimization and administrator productivity features.
[[["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-03-10 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."]]],[]]
