Side by side, read 10 Nov 2026
Google BigQuery and BigLake and Microsoft Fabric: the published facts in the same rows
Google BigQuery and BigLake profileMicrosoft Fabric profile
The same rows for both
| Row | Google BigQuery and BigLake | Microsoft Fabric |
|---|---|---|
| Kind | Serverless Google Cloud data warehouse | SaaS analytics on Azure with Spark |
| 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 Microsoft Learn, the native execution engine (Apache Gluten and Velox) needs no code changes, falls back to JVM Spark for unsupported operators and supports Parquet and Delta (read 2026-11-10). Per Microsoft Learn, OneLake S3 shortcuts give read-only access to data in an S3 bucket in any file format without copying it (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 Microsoft Learn, Fabric runs over OneLake on Azure and the region page lists Azure regions only, so Spark compute does not run inside AWS. Writes to S3 through a OneLake shortcut are not possible, and the method for Microsoft's native engine benchmark: none found on 2026-11-10. |
| 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. | Microsoft reports that on TPC-DS scale factor 1000 with Delta the native engine was up to six times faster than open-source Spark, with about 83% compute cost savings on a fixed-size cluster. |
| 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. | The Azure retail price API lists Fabric Spark capacity usage at $0.18 per CU-hour for eastus (Spark Memory Optimized and autoscale for Spark entries, pay-as-you-go). In Fabric each capacity unit maps to two Spark VCores, and Spark jobs are admitted by available VCores with FIFO queueing and throttling. Autoscale Billing for Spark is an opt-in pay-as-you-go model that runs Spark on dedicated serverless resources at standard PAYG CU-hour rates; reserved capacity discounts do not apply and a base capacity is still required. |
| 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. | The Fabric native execution engine, based on Apache Gluten and Velox, needs no code changes, falls back to JVM Spark for unsupported operators, and supports Parquet and Delta. |
| 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. | Starter pools start in 5 to 10 seconds with no setup; custom Spark pools let you tune node size and scaling, and native execution can be toggled per application with a Spark setting. |
| 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. | Fabric Runtime 1.3 uses Apache Spark 3.5 and Runtime 2.0 uses Spark 4.1; OneLake handles Delta and Iceberg through metadata virtualization so Iceberg tables read as Delta and vice versa. |
| 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. | Fabric workloads run over OneLake, described as built on Azure Data Lake Storage; the region availability page lists Azure regions and no AWS regions, so Spark compute does not run inside AWS. OneLake S3 shortcuts give read-only access to data in an S3 bucket in any file format without copying; file caching can reduce cross-cloud egress costs. Writes to S3 are not possible through the shortcut. |
| 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 | Microsoft Fabric (F128 capacity): $46.08 |
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 explains the cost lines.
Sources
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/omni-introduction, read 10 Nov 2026
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/spark-procedures, read 10 Nov 2026
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/iceberg-tables, read 10 Nov 2026
- Google BigQuery and BigLake: cloud.google.com/bigquery/docs/biglake-intro, read 10 Nov 2026
- Google BigQuery and BigLake: cloud.google.com/bigquery/pricing, read 10 Nov 2026
- Google BigQuery and BigLake: cloud.google.com/dataproc-serverless/pricing, read 10 Nov 2026
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview, read 10 Nov 2026
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/onelake/create-s3-shortcut, read 10 Nov 2026
- Microsoft Fabric: prices.azure.com/api/retail/prices?$filter=serviceName%20eq%20'Microsoft, read 10 Nov 2026
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-, read 10 Nov 2026
- Microsoft Fabric: azure.microsoft.com/en-us/pricing/details/microsoft-fabric, read 10 Nov 2026
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/runtime, read 10 Nov 2026
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/onelake/onelake-iceberg-tables, read 10 Nov 2026
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/spark-compute, read 10 Nov 2026
Last reviewed 10 Nov 2026.