Introduction to BigQuery editions

This document provides an introduction to BigQuery editions and the features associated with them.

Overview

BigQuery provides three editions (Standard, Enterprise, and Enterprise Plus) to support different types of workloads. These editions provide an alternative to existing reservation models. You can choose to use editions and on-demand models at the same time.

Each edition provides a set of capabilities at a different price point to match the requirements of different types of customers. You can create a reservation or a capacity commitment associated with an edition. Capacity commitments are not required to purchase slots, but can save on costs. For more information about slots autoscaling, see Introduction to slots autoscaling. As BigQuery editions is a property of compute power, not storage, you can query datasets regardless of how they are stored as long as you are not using a non-matching edition specific capability.

Editions features

The following table lists the features available in each edition. Features outside of your edition are blocked or lack functionality.

Standard Enterprise Enterprise Plus Non-edition offerings
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
Commitment plans 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 Monthly and annual commitment discounts
Monthly Service Level Objective (SLO)
>=99.9% >=99.99% >=99.99% >=99.99%
Compliance controls Compliance controls through Assured Workloads Compliance controls through Assured Workloads
VPC Service Controls VPC Service Controls Support VPC Service Controls Support VPC Service Controls Support
Data governance

Column-level access control

Row-level security

Dynamic data masking

Column-level access control

Row-level security

Dynamic data masking

Data egress

Data clean room subscriptions

Column-level access control

Row-level security

Dynamic data masking

Data egress

Storage encryption

Google-managed keys

Google-managed keys

Customer-managed keys (CMEK)

Google-managed keys

Customer-managed keys (CMEK)

Google-managed keys

Business Intelligence acceleration 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
Unstructured data Query object tables Object tables with ML inference Object tables with ML inference Query object tables
Integrated machine learning 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 do not have access to Advanced workload management

Supported assignment types QUERY,
PIPELINE
QUERY, PIPELINE, ML_EXTERNAL, BACKGROUND QUERY, PIPELINE, ML_EXTERNAL, BACKGROUND QUERY, PIPELINE, ML_EXTERNAL, BACKGROUND
Multi-cloud analytics BigQuery Omni support BigQuery Omni support

Edition tiers should not be used to restrict access to specific features, as the features assigned to each edition could change over time. For example, do not 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 key encryption keys used to protect your data. You can also use customer-managed encryption keys (CMEK) in 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