Some or all of the information on this page might not apply to Trusted Cloud by S3NS.
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
|
Standard |
Enterprise |
Enterprise Plus |
On-demand pricing |
Pricing model |
Slot-hours (1 minute minimum) |
Slot-hours (1 minute minimum) |
Slot-hours (1 minute minimum) |
Pay per query with free tier |
Monthly Service Level Objective (SLO)
|
>=99.9% |
>=99.99% |
>=99.99% |
>=99.99% |
Compliance controls |
No access to compliance controls through Assured Workloads |
No access to compliance controls through Assured Workloads |
Compliance controls through Assured Workloads |
Compliance controls through Assured Workloads |
Business Intelligence acceleration |
No access to query acceleration through BI Engine |
Query acceleration through BI Engine |
Query acceleration through BI Engine |
Query acceleration through BI Engine |
Workload management |
Users cannot set the maximum concurrency target |
Advanced workload management (idle capacity sharing, target concurrency) |
Advanced workload management (idle capacity sharing, target concurrency) |
On-demand users don't have access to Advanced workload management
|
Compute model |
Autoscaling |
Autoscaling + Baseline |
Autoscaling + Baseline |
On-demand |
Maximum reservation size |
1,600 slots |
Quota |
Quota |
Quota |
Maximum reservations per administration project |
10 |
200 |
200 |
No access to reservations |
Commitment plans |
No access to capacity commitments |
1-year commitment at 20% discount or 3-year commitment at 40% discount |
1-year commitment at 20% discount or 3-year commitment at 40% discount |
No access to capacity commitments |
Assignments |
Project assignments |
Project, folder, or organization assignments |
Project, folder, or organization assignments |
No assignments |
Supported assignment types |
QUERY ,
PIPELINE |
QUERY , CONTINUOUS , PIPELINE , ML_EXTERNAL , BACKGROUND |
QUERY , CONTINUOUS , PIPELINE , ML_EXTERNAL , BACKGROUND |
On-demand pricing doesn't support assignments |
Managed disaster recovery |
No access to managed disaster recovery |
No access to managed disaster recovery |
Managed disaster recovery |
No access to managed disaster recovery |
Data export |
No access to exporting data to Bigtable |
Exporting data to Bigtable |
Exporting data to Bigtable |
No access to exporting data to Bigtable |
Analysis features
|
Standard |
Enterprise |
Enterprise Plus |
On-demand pricing |
Data sharing |
Entity resolution framework
Publish and subscribe to datasets
Data clean room subscriptions
Egress controls
|
Entity resolution framework
Publish and subscribe to datasets
Data clean room subscriptions
Egress controls
|
Entity resolution framework
Publish and subscribe to datasets
Data clean room subscriptions
Egress controls
|
Entity resolution framework
Publish and subscribe to datasets
Data clean room subscriptions
Egress controls
|
Materialized views |
Query existing materialized views directly |
Create materialized views
Automatic refresh of materialized views
Manual refresh of materialized views
Direct query of materialized views
Smart tuning
|
Create materialized views
Automatic refresh of materialized views
Manual refresh of materialized views
Direct query of materialized views
Smart tuning
|
Create materialized views
Automatic refresh of materialized views
Manual refresh of materialized views
Direct query of materialized views
Smart tuning
|
Cached results |
Single-user caching |
Cross-user caching |
Cross-user caching |
Single-user caching |
Continuous queries
(Preview) |
No access to continuous queries |
Continuous queries |
Continuous queries |
No access to continuous queries |
Search |
Access to the SEARCH function without access to search indexes |
Query acceleration with search indexes |
Query acceleration with search indexes |
Query acceleration with search indexes |
Vector search |
Access to the VECTOR_SEARCH function without access to vector indexes |
Query acceleration with vector indexes |
Query acceleration with vector indexes |
Query acceleration with vector indexes |
Unstructured data |
Run SQL queries on object tables |
Perform ML inference on object tables using remote models:
|
Perform ML inference on object tables using remote models:
|
Perform ML inference on object tables using remote models:
|
Multi-cloud analytics |
Not available |
BigQuery Omni support |
Not available |
BigQuery Omni support |
Integrated machine learning |
No access to BigQuery ML |
BigQuery ML |
BigQuery ML |
BigQuery ML |
Workload management |
Users cannot set the maximum concurrency target |
Advanced workload management (idle capacity sharing, target concurrency) |
Advanced workload management (idle capacity sharing, target concurrency) |
On-demand users don't have access to Advanced workload management
|
Supported assignment types |
QUERY ,
PIPELINE |
QUERY , CONTINUOUS , PIPELINE , ML_EXTERNAL , BACKGROUND |
QUERY , CONTINUOUS , PIPELINE , ML_EXTERNAL , BACKGROUND |
On-demand pricing doesn't support assignments |
VPC Service Controls |
No VPC Service Controls Support |
VPC Service Controls Support |
VPC Service Controls Support |
VPC Service Controls Support |
Data export |
No access to exporting data to Bigtable
or exporting data to Spanner |
Exporting data to Bigtable
or exporting data to Spanner |
Exporting data to Bigtable
or exporting data to Spanner |
No access to exporting data to Bigtable
or exporting data to Spanner |
Storage encryption |
Google Cloud-powered encryption keys
|
Customer-managed keys (CMEK)
Google Cloud-powered encryption keys
|
Customer-managed keys (CMEK)
Google Cloud-powered encryption keys
|
Customer-managed keys (CMEK)
Google Cloud-powered encryption keys
|
Fine-grained security controls |
No access to fine-grained security controls |
Column-level access control
Row-level security
Dynamic data masking
Custom data masking
|
Column-level access control
Row-level security
Dynamic data masking
Custom data masking
|
Column-level access control
Row-level security
Dynamic data masking
Custom data masking
|
What's next
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-07-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 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."]]],[]]