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

Side by side, read 10 Nov 2026

**The short answer.** Databricks (Managed lakehouse built around Delta Lake) and Google BigQuery and BigLake (Serverless Google Cloud data warehouse) 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: Databricks on AWS (Jobs Compute): $32.40; BigQuery (Enterprise edition slots): $19.20.

## The same rows for both

| Row | Databricks | Google BigQuery and BigLake |
| --- | --- | --- |
| Kind | Managed lakehouse built around Delta Lake | Serverless Google Cloud data warehouse |
| Does well | Per Databricks documentation, Photon keeps the Spark Catalyst planner, works with existing Spark API code and falls back to the Spark runtime for unsupported operations (read 2026-11-10). Per Databricks documentation, Delta tables can generate Iceberg metadata from Runtime 14.3 LTS, so Iceberg clients read Delta data without rewriting files (read 2026-11-10). | 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). |
| Limited | Per Databricks documentation, serverless compute supports only Spark Connect APIs, so RDD APIs, R and Maven coordinates are unsupported, and ANSI mode on by default can change results of existing jobs. Per Databricks, compute is billed in DBUs in addition to the cloud bill for the same instances, so a Jobs Compute run pays Databricks and AWS separately; the Compute Bill line adds $12.24 of DBUs to $20.16 of EC2 (read 2026-11-10). | 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 | Docs claim Photon gives up to 5x better price/performance for data and analytics workloads versus other cloud data warehouses; no method is given on this page. Databricks announced an audited 100TB TPC-DS result of 32,941,245 QphDS for Databricks SQL, 2.2x the previous record held by Alibaba, with total system cost 10% lower on list pricing. This is a SQL warehouse result, not a Spark batch ETL result. The same Databricks blog says research from Barcelona Supercomputing Center found Databricks 2.7x faster and 12x better in price-performance than Snowflake on a TPC-DS derivative. This is a vendor-reported claim of a third-party study; the study itself was not fetched. | 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. |
| Published prices and cost results | Databricks bills compute in DBUs at per-second granularity with pay-as-you-go or committed-use discounts, and no up-front costs. The pricing pages render their rates by script; the AWS pricing data file those pages load lists Jobs Compute at $0.15 per DBU on the plan it names Premium (r6i.4xlarge: 4.08 DBU per hour). The file names no region. Jobs pricing offers serverless (Performance Optimized and Standard modes) and classic clusters; the jobs pricing page maps plan names across clouds (its Premium tier on Azure corresponds to Enterprise on AWS and GCP), while the AWS pricing data file lists the $0.15 Jobs Compute rate under a plan it names Premium. Photon instances consume DBUs at a different rate. | 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. |
| Code changes and migration | Photon is a native C++ vectorized engine that keeps Spark's Catalyst planner and works with existing Spark API code; unsupported operations fall back to the Spark runtime. Serverless compute for notebooks and jobs supports only Spark Connect APIs; Spark RDD APIs, R, Maven coordinates, global temp views, DBFS mounts with instance profiles and Databricks Container Services are not supported. ANSI mode is on by default and the default time zone is UTC, which can change results of existing jobs. | 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. |
| Tuning and table upkeep | Photon is on by default for classic all-purpose compute, jobs compute and classic pipelines; API users must set runtime_engine to PHOTON. Photon instance types use DBUs at a different rate than the same instance without Photon. On serverless compute Databricks allocates and manages compute so users do not provision clusters; the Spark UI and Spark logs are not available, query profile and client-side logs are used instead. Serverless compute runs workloads without provisioning compute in your cloud account, and Databricks says this reduces the need to manage compute resources. It requires Unity Catalog to reach external data sources. | 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. |
| Spark versions and table formats | Databricks Runtime 18 LTS ships Apache Spark 4.1.0 (released June 10, 2026); Runtime 17.3 LTS ships Spark 4.0.0; Runtime 16.4 LTS and 15.4 LTS ship Spark 3.5.x. Runtime 19 ships Spark 4.2.0 (July 23, 2026). Delta Lake tables can generate Iceberg metadata (UniForm, Iceberg reads) from Databricks Runtime 14.3 LTS so Iceberg clients read Delta data without rewriting files. | 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. |
| Where it runs | Databricks on AWS lists many AWS regions including us-east-1 (US East, Northern Virginia), us-east-2, us-west-1, eu-west-1, eu-central-1, ap-southeast-2 and us-gov-west-1; the platform is also hosted on Azure and Google Cloud. Some features are only in a subset of regions. | 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. |
| How open its benchmarks are | None found on 10 Nov 2026. | None found on 10 Nov 2026. |
| Compute Bill | Databricks on AWS (Jobs Compute): $32.40 | BigQuery (Enterprise edition slots): $19.20 |

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

- Databricks Data Intelligence Platform on AWS: docs.databricks.com/aws/en/compute/photon: https://docs.databricks.com/aws/en/compute/photon (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: docs.databricks.com/aws/en/compute/serverless/limitations: https://docs.databricks.com/aws/en/compute/serverless/limitations (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: docs.databricks.com/aws/en/compute/serverless: https://docs.databricks.com/aws/en/compute/serverless/ (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: docs.databricks.com/aws/en/release-notes/runtime: https://docs.databricks.com/aws/en/release-notes/runtime/ (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: docs.databricks.com/aws/en/delta/uniform: https://docs.databricks.com/aws/en/delta/uniform (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: docs.databricks.com/aws/en/resources/supported-regions: https://docs.databricks.com/aws/en/resources/supported-regions (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: databricks.com/blog/2021/11/02/databricks-sets-official-data-warehousing: https://www.databricks.com/blog/2021/11/02/databricks-sets-official-data-warehousing-performance-record.html (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: databricks.com/product/aws-pricing: https://www.databricks.com/product/aws-pricing (read 10 Nov 2026)
- Databricks Data Intelligence Platform on AWS: databricks.com/product/pricing/jobs: https://www.databricks.com/product/pricing/jobs (read 10 Nov 2026)
- 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/compare/bigquery-biglake-vs-databricks/
