# Google BigQuery and BigLake, Serverless Google Cloud data warehouse: the published facts

Platform profile, read 10 Nov 2026

**The short answer.** Google BigQuery is a serverless warehouse on Google Cloud with Iceberg managed tables, BigLake tables over Cloud Storage and S3, and Spark stored procedures that run PySpark or Scala code from SQL. BigQuery Omni reads S3 data in six AWS regions, but it does not support DML or CREATE TABLE.

- **Kind:** Serverless Google Cloud data warehouse
- **Website:** [cloud.google.com/bigquery](https://cloud.google.com/bigquery)
- **Name checked:** BigQuery and BigLake still exist. Dataproc, which runs Spark, is now titled Managed Service for Apache Spark (formerly Dataproc) on its pricing page; Serverless Spark inside BigQuery is documented as stored procedures for Apache Spark.
- **Read:** 10 Nov 2026

## What it does well

- Per Google documentation, BigQuery Iceberg managed tables store data in buckets you own, support DML and streaming, and run automatic compaction, clustering and garbage collection (read 2026-11-10).
- Per Google documentation, stored procedures for Apache Spark run PySpark or Scala/Java JAR code from SQL on Google Cloud (read 2026-11-10).

## Where it is limited

- Per Google documentation, BigQuery Omni on S3 does not support DML or CREATE TABLE, so it does not run write-heavy Spark batch ETL on S3.
- Google's pricing page text lists Enterprise edition compute at $0.06 per slot-hour, with no region shown beside the rate (read 2026-11-10). Per-TiB on-demand and Spark DCU rates are not used on this site.

## Published speed results

| Fact | Source type | Source, read |
| --- | --- | --- |
| Google states Lightning Engine delivers up to 4.9x faster performance than open source Spark and up to 2.5x the price-performance over a high-speed Spark offering Google does not name; no method is given on the pricing page. | vendor | [cloud.google.com/dataproc-serverless/pricing](https://cloud.google.com/dataproc-serverless/pricing), 10 Nov 2026 |

## Published prices and cost results

| Fact | Source type | Source, read |
| --- | --- | --- |
| BigQuery offers on-demand pricing per TiB scanned (first 1 TiB per month free) or capacity pricing per slot-hour. BigQuery Omni has its own on-demand per TiB pricing for AWS regions. The page text shows $0.06 per slot-hour for Enterprise edition pay-as-you-go compute, with no region shown beside the rate (read 2026-11-10). | vendor docs | [cloud.google.com/bigquery/pricing](https://cloud.google.com/bigquery/pricing), 10 Nov 2026 |
| Google's Spark service (Managed Service for Apache Spark, formerly Dataproc) bills serverless Spark per second in Data Compute Units with a 1-minute minimum, plus shuffle storage; Standard tier is for batch ETL, Premium tier uses Lightning Engine. | vendor docs | [cloud.google.com/dataproc-serverless/pricing](https://cloud.google.com/dataproc-serverless/pricing), 10 Nov 2026 |

## Code changes and migration

| Fact | Source type | Source, read |
| --- | --- | --- |
| On BigQuery Omni, DML statements and CREATE TABLE are not supported, BigQuery ML statements are not supported, and only EXPORT DATA queries are allowed for destination tables, so it does not run write-heavy Spark batch ETL on S3. Standard and Enterprise Plus editions do not support Omni regions. | cloud provider docs | [cloud.google.com/bigquery/docs/omni-introduction](https://cloud.google.com/bigquery/docs/omni-introduction), 10 Nov 2026 |
| BigQuery stored procedures for Apache Spark let you run PySpark or Scala/Java JAR code from SQL via CREATE PROCEDURE ... OPTIONS(engine = "SPARK", runtime_version = "2.2"), using a Cloud Storage file or inline code and a connection; this runs on Google Cloud, so code must be wrapped as procedures. | cloud provider docs | [cloud.google.com/bigquery/docs/spark-procedures](https://cloud.google.com/bigquery/docs/spark-procedures), 10 Nov 2026 |

## Tuning and table upkeep

| Fact | Source type | Source, read |
| --- | --- | --- |
| Iceberg managed tables run automatic storage optimization (adaptive file sizing, clustering, garbage collection), so compaction needs no job configuration on Google Cloud; storage optimization is a separate billed item. | cloud provider docs | [cloud.google.com/bigquery/docs/iceberg-tables](https://cloud.google.com/bigquery/docs/iceberg-tables), 10 Nov 2026 |

## Spark versions and table formats

| Fact | Source type | Source, read |
| --- | --- | --- |
| BigQuery Iceberg managed tables store data in buckets you own, support DML, streaming and Spark connectors, export Iceberg V2 snapshots for open engines, and do automatic compaction, clustering and garbage collection. | cloud provider docs | [cloud.google.com/bigquery/docs/iceberg-tables](https://cloud.google.com/bigquery/docs/iceberg-tables), 10 Nov 2026 |
| BigLake tables let you query structured data in Cloud Storage, Amazon S3 and Blob Storage with access delegation and row and column security. | cloud provider docs | [cloud.google.com/bigquery/docs/biglake-intro](https://cloud.google.com/bigquery/docs/biglake-intro), 10 Nov 2026 |

## Where it runs

| Fact | Source type | Source, read |
| --- | --- | --- |
| BigQuery Omni lets BigQuery analytics run on data in Amazon S3 through BigLake tables, in AWS regions us-east-1, us-west-2, ap-northeast-2, ap-southeast-2, eu-west-1 and eu-central-1. | cloud provider docs | [cloud.google.com/bigquery/docs/omni-introduction](https://cloud.google.com/bigquery/docs/omni-introduction), 10 Nov 2026 |

## On the Compute Bill

| Line | How it is billed | Formula | Stated cost | What is in and out |
| --- | --- | --- | --- | --- |
| [BigQuery (Enterprise edition slots)](/platforms/bigquery-biglake/) | Per slot-hour for the edition used, billed per second with a one-minute minimum. A slot is described by Google as a virtual CPU. | 160 slots (one per vCPU of the reference job) x 2 hours = 320 slot-hours. 320 x $0.06 = $19.20. | $19.20 | Includes slot compute only. Excludes storage, and excludes any data movement into or out of AWS. BigQuery runs SQL on Google's slots, not Spark on EC2, so this line prices the same amount of vCPU time, not the same Spark job. The text of the pricing page lists one rate for the Enterprise edition without showing which region the rate belongs to, so the region is not confirmed here. |

## Searched for and none found on 10 Nov 2026

- Dollar rates for BigQuery per TiB, Omni and DCU in readable page text (the Enterprise slot-hour rate, $0.06, was read) (searched: cloud.google.com/bigquery/pricing, cloud.google.com/dataproc-serverless/pricing)
- Published scripts for Lightning Engine benchmark (searched: cloud.google.com/dataproc-serverless/pricing)
- Spark version supported by BigQuery stored procedures beyond runtime_version 2.2 example (searched: cloud.google.com/bigquery/docs/spark-procedures)

## Google BigQuery and BigLake side by side with each other entry

- [Google BigQuery and BigLake and Amazon EMR plus Athena on Iceberg](/compare/aws-emr-athena-iceberg-vs-bigquery-biglake/)
- [Google BigQuery and BigLake and Databricks](/compare/bigquery-biglake-vs-databricks/)
- [Google BigQuery and BigLake and Dremio](/compare/bigquery-biglake-vs-dremio/)
- [Google BigQuery and BigLake and DualBird](/compare/bigquery-biglake-vs-dualbird/)
- [Google BigQuery and BigLake and Microsoft Fabric](/compare/bigquery-biglake-vs-microsoft-fabric/)
- [Google BigQuery and BigLake and Onehouse](/compare/bigquery-biglake-vs-onehouse/)
- [Google BigQuery and BigLake and Open stack on EMR and EKS](/compare/bigquery-biglake-vs-open-stack-emr-eks/)
- [Google BigQuery and BigLake and Snowflake](/compare/bigquery-biglake-vs-snowflake/)
- [Google BigQuery and BigLake and Starburst](/compare/bigquery-biglake-vs-starburst/)

## Sources

- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/omni-introduction: https://cloud.google.com/bigquery/docs/omni-introduction (read 10 Nov 2026)
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/spark-procedures: https://cloud.google.com/bigquery/docs/spark-procedures (read 10 Nov 2026)
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/iceberg-tables: https://cloud.google.com/bigquery/docs/iceberg-tables (read 10 Nov 2026)
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/biglake-intro: https://cloud.google.com/bigquery/docs/biglake-intro (read 10 Nov 2026)
- Google BigQuery and BigLake: cloud.google.com/bigquery/pricing: https://cloud.google.com/bigquery/pricing (read 10 Nov 2026)
- Google BigQuery and BigLake: cloud.google.com/dataproc-serverless/pricing: https://cloud.google.com/dataproc-serverless/pricing (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/platforms/bigquery-biglake/
