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

Customer-managed keys (CMEK)

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 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:
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
Data export No access to exporting data to Bigtable Exporting data to Bigtable Exporting data to Bigtable No access to exporting data to Bigtable

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 edition and 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