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-02-27 UTC."],[],[]]
