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.
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.
BigQuery editions features
The following table lists the features available in each edition. Features
outside of your edition are blocked or lack capabilities.
|
|
BigQuery editions |
|
On-demand pricing |
|
Standard |
Enterprise |
Enterprise Plus |
Pricing model |
Slot-hours (1 minute minimum) |
Slot-hours (1 minute minimum) |
Slot-hours (1 minute minimum) |
Pay per query with free tier |
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 |
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 |
VPC Service Controls |
No VPC Service Controls Support |
VPC Service Controls Support |
VPC Service Controls Support |
VPC Service Controls Support |
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
|
Data sharing |
Entity resolution framework
Publish and subscribe to datasets
|
Entity resolution framework
Publish and subscribe to datasets
|
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
|
Storage encryption |
Google-owned and Google-managed keys
|
Google-owned and Google-managed keys
|
Customer-managed keys (CMEK)
Google-owned and Google-managed keys
|
Customer-managed keys (CMEK)
Google-owned and Google-managed keys
|
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 |
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
|
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 |
Query object tables |
Object tables with ML inference |
Object tables with ML inference |
Object tables with ML inference against remote models: LLM, Cloud AI services, Vertex AI hosted models |
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 |
Multi-cloud analytics |
Not available |
BigQuery Omni support |
Not available |
BigQuery Omni support |
Cached results |
Single-user caching |
Cross-user caching |
Cross-user caching |
Single-user caching |
Assignments |
Project assignments |
Project, folder, or organization assignments |
Project, folder, or organization assignments |
No 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 |
Continuous queries
(Preview) |
No access to continuous queries |
Continuous queries |
Continuous queries |
No access to continuous queries |
Edition tiers shouldn't be used to restrict access to specific features, as the
features assigned to each edition could change over time. For example, don't
assign projects to Standard edition reservations just to disable
BigQuery ML.
Storage encryption support
BigQuery automatically encrypts all data
at rest. By default, Google manages the encryption keys used to protect your
data. You can also use customer-managed encryption keys (CMEK)
in the Enterprise Plus edition.
Assured Workloads support
BigQuery Enterprise Plus edition supports
Assured Workloads platform controls
for regulatory compliance regimes, including FedRAMP, CJIS, IL4, and ITAR.
Pricing
For information about BigQuery editions pricing, see BigQuery pricing.
Quotas
Slots from all editions are subject to the same quota. Your quota is not
fulfilled on a per-edition basis. For information about quotas, see Quotas and
limits.
What's next