Stay organized with collections Save and categorize content based on your preferences.
Understand BigQuery editionsBigQuery 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 featuresThe 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)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 typesQUERY,
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 Note: BigQuery Enterprise Plus edition supports Assured Workloads platform controls for regulatory compliance regimes, including FedRAMP, CJIS, IL4, and ITAR. Analysis features Standard Enterprise Enterprise Plus On-demand pricing Data sharing
Publish and subscribe to datasets
Publish and subscribe to datasets
Publish and subscribe to datasets
Publish and subscribe to datasets
Materialized views Query existing materialized views directlyAutomatic refresh of materialized views
Manual refresh of materialized views
Direct query of materialized views
Automatic refresh of materialized views
Manual refresh of materialized views
Direct query of materialized views
Automatic refresh of materialized views
Manual refresh of materialized views
Direct query of materialized views
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 theSEARCH 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 typesQUERY,
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-owned and Google-managed encryption keys
Google-owned and Google-managed encryption keys
Google-owned and Google-managed encryption keys
Google-owned and Google-managed encryption keys
Fine-grained security controls No access to fine-grained security controls Note: 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. What's nextExcept 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-08-07 UTC.
[[["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-08-07 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."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4