# Google BigQuery and BigLake and Starburst: the published facts in the same rows

Side by side, read 10 Nov 2026

**The short answer.** Google BigQuery and BigLake (Serverless Google Cloud data warehouse) and Starburst (Managed Trino service for Iceberg) are set out here in the same rows: published speed and cost results, code changes, table upkeep, table formats and where each runs. On the Compute Bill's reference job: BigQuery (Enterprise edition slots): $19.20; Starburst Galaxy (Pro tier): $60.00.

## The same rows for both

| Row | Google BigQuery and BigLake | Starburst |
| --- | --- | --- |
| Kind | Serverless Google Cloud data warehouse | Managed Trino service for Iceberg |
| 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). | Per Starburst documentation, Galaxy creates and writes Iceberg tables (Parquet, ORC or Avro) and runs maintenance with ALTER TABLE ... EXECUTE optimize, expire_snapshots and remove_orphan_files (read 2026-11-10). Starburst publishes credit prices by AWS region, for example $0.50 (Pro) and $0.75 (Enterprise) in US East (N. Virginia) and $0.60 and $0.90 in Frankfurt (read 2026-11-10). |
| 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. | Per Starburst documentation, Galaxy runs SQL on Trino, not Spark, so DataFrame code, UDFs and PySpark would be rewritten as Trino SQL or kept on Spark (read 2026-11-10). Per Starburst documentation, Hudi tables are read-only in Galaxy: it cannot create new Hudi tables or write to them. |
| Published speed results | 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. | Starburst reported GPU-accelerated Trino results (its proprietary distribution, not open-source Trino): TPC-H up to 6x on accelerated queries and ClickBench 3.4x overall, single-node development environment. This is a SQL query test, not Spark batch work. |
| Published prices and cost results | 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). 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. | Galaxy credit prices start at $0.50 (Pro), $0.75 (Enterprise) and $1.00 (Mission Critical) per credit. A Free tier allows up to 3 clusters. Pricing depends on compute usage, tier and the cloud provider and region. Annual commitments may get discounts. On-demand list prices per credit (Pro / Enterprise / Mission Critical) on AWS: US East N. Virginia, US East Ohio and US West Oregon $0.50 / $0.75 / $1.00; Europe Ireland $0.56 / $0.84 / $1.12; Europe Frankfurt $0.60 / $0.90 / $1.20; Asia Pacific Tokyo $0.64 / $0.97 / $1.29; Brazil (Sao Paulo) $0.80 / $1.19 / $1.59. Cluster compute credit consumption: 1 worker 6 credits per hour, 2 workers 12, 4 workers 24, 8 workers 48, 16 workers 96. Managed ingest: file ingest 0.60 credits per hour; table maintenance and data transforms 0.30 credits per hour. Billing tracks cluster compute hours, data ingestion compute and private link data transfer. |
| Code changes and migration | 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. 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. | Galaxy is 'a fully-managed data lake analytics platform built in addition to Trino'. Work runs as SQL on Trino, not Spark, so Spark jobs (DataFrame code, UDFs, PySpark) would have to be rewritten as Trino SQL, or kept on Spark against the same Iceberg tables. The Galaxy docs read contain no Spark execution mode. |
| Tuning and table upkeep | 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. | Iceberg table maintenance in Galaxy is run with ALTER TABLE ... EXECUTE commands: optimize (compaction; files under file_size_threshold, default 100MB, are merged), drop_extended_stats, expire_snapshots, remove_orphan_files. Live table maintenance for ingest tables is a separate Galaxy page. For batch-style work Galaxy offers a fault tolerant execution mode that spools intermediate data and retries failed parts of a query. Docs say 'No other configuration is required' to enable it, but not to use it if most queries run under about a minute, and that it can be slightly slower than normal execution. FTE and Accelerated modes are not available on the Free cluster size and not all catalogs support FTE. |
| Spark versions and table formats | 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. BigLake tables let you query structured data in Cloud Storage, Amazon S3 and Blob Storage with access delegation and row and column security. | Galaxy's Great Lakes connectivity lists Iceberg, Delta Lake, Hive and Hudi table format pages. Hudi tables are read-only: 'Galaxy cannot create new Hudi tables or write to them.' Iceberg tables can be created and written; the Iceberg data file format can be Parquet, ORC or Avro. |
| Where it runs | 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. | Galaxy prices are listed for AWS, Azure and GCP regions. AWS regions priced include us-east-1, us-east-2, us-west-1, us-west-2, ca-central, Ireland, London, Frankfurt, Zurich, Singapore, Sydney, Tokyo, Cape Town, UAE, Tel Aviv and Sao Paulo. A cluster and its catalogs are normally in the same cloud and region; cross-region querying is a private preview feature. |
| How open its benchmarks are | None found on 10 Nov 2026. | None found on 10 Nov 2026. |
| Compute Bill | BigQuery (Enterprise edition slots): $19.20 | Starburst Galaxy (Pro tier): $60.00 |

Alphabetical order. Vendor statements are the vendor's own. Read 10 Nov 2026.

## How to read this page

The rows hold what each vendor or a named third party published, with no conclusion drawn. Benchmarks in the two columns ran on different hardware, data and baselines, so their numbers are not comparable across columns. The [Compute Bill method](/compute-bill/method/) explains the cost lines.

## 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)
- Starburst (Starburst Galaxy, Starburst Enterprise): starburst.io/pricing: https://www.starburst.io/pricing/ (read 10 Nov 2026)
- Starburst (Starburst Galaxy, Starburst Enterprise): starburst.io/pricing/pricing-details: https://www.starburst.io/pricing/pricing-details/ (read 10 Nov 2026)
- Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/index.html: https://docs.starburst.io/starburst-galaxy/index.html (read 10 Nov 2026)
- Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/data-engineering/working-with-data-la: https://docs.starburst.io/starburst-galaxy/data-engineering/working-with-data-lakes/table-formats/gl-hudi.html (read 10 Nov 2026)
- Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/data-engineering/working-with-data-la: https://docs.starburst.io/starburst-galaxy/data-engineering/working-with-data-lakes/table-formats/gl-iceberg.html (read 10 Nov 2026)
- Starburst (Starburst Galaxy, Starburst Enterprise): docs.starburst.io/starburst-galaxy/data-engineering/optimization-perform: https://docs.starburst.io/starburst-galaxy/data-engineering/optimization-performance-and-quality/workload-optimization/clusters-with-fte.html (read 10 Nov 2026)
- Starburst (Starburst Galaxy, Starburst Enterprise): starburst.io/blog/gpu-accelerated-sql-analytics-how-starburst-and-nvidia: https://www.starburst.io/blog/gpu-accelerated-sql-analytics-how-starburst-and-nvidia-deliver-industry-benchmark-speedups-on-gpu-infrastructure/ (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/compare/bigquery-biglake-vs-starburst/
