# Microsoft Fabric and Snowflake: the published facts in the same rows

Side by side, read 10 Nov 2026

**The short answer.** Microsoft Fabric (SaaS analytics on Azure with Spark) and Snowflake (Cloud data platform with PySpark support) 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: Microsoft Fabric (F128 capacity): $46.08; Snowflake (XL standard warehouse): $96.00.

## The same rows for both

| Row | Microsoft Fabric | Snowflake |
| --- | --- | --- |
| Kind | SaaS analytics on Azure with Spark | Cloud data platform with PySpark support |
| Does well | 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). | Per Snowflake documentation, Snowpark Connect runs existing PySpark DataFrame code against the Snowflake engine over Spark Connect, and batch jobs are submitted with the Snowpark Submit CLI (read 2026-11-10). Per Snowflake documentation, Iceberg tables can keep data in customer-managed S3, GCS or Azure storage through external volumes and a catalog integration such as AWS Glue. |
| Limited | 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. | Per Snowflake documentation, Snowpark Connect supports Apache Spark 3.5 only, and DayTimeIntervalType, YearMonthIntervalType and user-defined types are unsupported (read 2026-11-10). On-demand credit prices on AWS US East (Northern Virginia) are $2.00 (Standard), $3.00 (Enterprise) and $4.00 (Business Critical) per the Snowflake Service Consumption Table effective 2026-11-09 (read 2026-11-10); the Snowflake pricing page itself renders by script. |
| Published speed results | 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. | None found on 10 Nov 2026. |
| Published prices and cost results | 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. | Warehouses bill credits per second with a 60-second minimum on each start; each size step roughly doubles credits per hour (Small is 2 credits per hour, Medium is 4). Snowflake's Service Consumption Table (effective 2026-11-09) lists on-demand credits on AWS US East at $2.00 (Standard), $3.00 (Enterprise) and $4.00 (Business Critical). |
| Code changes and migration | 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. | Snowpark Connect for Apache Spark runs existing PySpark DataFrame code against the Snowflake engine over the Spark Connect protocol; there is no Spark cluster, all workloads run on a Snowflake warehouse. Batch jobs are submitted with the Snowpark Submit CLI. Because Snowflake rather than Spark is the engine, there are semantic differences: DayTimeIntervalType, YearMonthIntervalType and user-defined types are unsupported, and ByteType, ShortType and IntegerType are returned as LongType. The docs list unsupported APIs for DataFrame and Dataset. Docs say the Spark DataFrame and Spark SQL code can be reused with minimal migration or changes; the compatibility notes say Spark Connect defers plan resolution, which changes behavior versus Spark Classic. |
| Tuning and table upkeep | 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. | Docs provide a separate Optimizing Snowpark Connect for Spark workloads section and a Troubleshooting section covering known limitations, so some job-level adjustment is expected after migration. |
| Spark versions and table formats | 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. | Snowpark Connect supports Apache Spark 3.5 only; workloads written for 3.4 and below or 4.0 and above are not supported and may produce protocol errors or missing API failures. Snowflake supports Iceberg tables (Parquet) with data in customer-managed S3, GCS or Azure storage via external volumes, an external catalog integration such as AWS Glue, and Delta files read through Delta Direct; Hudi was not listed on the page. |
| Where it runs | 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. | Snowflake runs on AWS, Azure and Google Cloud; AWS regions include us-east-1, us-west-2, eu-west-1 and ca-central-1. Each account is hosted in a single region. |
| How open its benchmarks are | None found on 10 Nov 2026. | None found on 10 Nov 2026. |
| Compute Bill | Microsoft Fabric (F128 capacity): $46.08 | Snowflake (XL standard warehouse): $96.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

- Microsoft Fabric: learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview: https://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: https://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: https://prices.azure.com/api/retail/prices?$filter=serviceName%20eq%20'Microsoft%20Fabric'%20and%20armRegionName%20eq%20'eastus'%20and%20priceType%20eq%20'Consumption' (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-: https://learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-and-queueing (read 10 Nov 2026)
- Microsoft Fabric: azure.microsoft.com/en-us/pricing/details/microsoft-fabric: https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/ (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/runtime: https://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: https://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: https://learn.microsoft.com/en-us/fabric/data-engineering/spark-compute (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-: https://docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-apache-spark (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-: https://docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-limitations.md (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-: https://docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-compatibility.md (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/user-guide/cost-understanding-compute: https://docs.snowflake.com/en/user-guide/cost-understanding-compute (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/user-guide/tables-iceberg: https://docs.snowflake.com/en/user-guide/tables-iceberg (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/user-guide/intro-regions.md: https://docs.snowflake.com/en/user-guide/intro-regions.md (read 10 Nov 2026)
- Snowflake: docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-: https://docs.snowflake.com/en/developer-guide/snowpark-connect/snowpark-connect-troubleshooting.md (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/compare/microsoft-fabric-vs-snowflake/
