No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Fabric vs Snowflake comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft Fabric
Average Rating
7.6
Number of Reviews
3
Ranking in other categories
Data Management Platforms (DMP) (9th)
Snowflake
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
106
Ranking in other categories
Data Warehouse (1st), Cloud Data Warehouse (1st), AI Synthetic Data (1st), Database Management Systems (DBMS) (3rd), AI Software Development (6th)
 

Featured Reviews

Ankush-Singh - PeerSpot reviewer
Lead Software Engineer at Momentus
Unified analytics platform has simplified complex dashboards and supported secure data pipelines
One thing about Microsoft Fabric that I think could be improved is the potential confusion when working with real-time data versus normal batch loading. If you are dealing with real-time databases or data, you need to work with Event Hub and event streaming, but for normal batch processing, you can usually go ahead with the SQL warehouse or the data lakehouse. I recommend that Microsoft unify these processes, so using one source can meet both requirements. If I am working with real-time data and batched data, I should not have to manage two separate systems; instead of creating an Event Hub and a lakehouse, users could simply manage one house to handle both real-time analysis and batch processing, making it simpler and more user-friendly from both business and development perspectives.
SunilPatil1 - PeerSpot reviewer
Asset Builder at Genpact - Headstrong
Have prioritized security while managing multi-agent data migration and cloud adoption
We utilize Time Travel with Snowflake because this is a very useful feature. Everyone finds it crucial because in conventional data platforms, it's very difficult to handle these kinds of things. This feature is essential, though I don't have the use cases currently; it is just there for implementation. Regarding Snowflake's automated scaling and suspension features, this auto-scaling is very significant. We had a comparison with Databricks and Snowflake a few months back, and this auto-scaling takes an edge within Snowflake; that's what our observation reflects.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable and useful feature I have found in Microsoft Fabric is data consistency, which is the top thing."
"The best feature Microsoft Fabric offers in my experience is the Dataflow."
"The features and capabilities of Microsoft Fabric that I have found most useful include it being a uniform platform."
"The solution's customer service is good."
"Snowflake's most valuable features are data enrichment and flattening."
"The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"Snowflake solves many of the challenges that traditional data warehousing tools have such as a lack of agility, scalability and fine-tuning."
"The way Snowflake has emerged in the past few years is impressive."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
 

Cons

"In my experience, Microsoft Fabric is not stable."
"I think the Copilot usage in Microsoft Fabric can be improved."
"One thing about Microsoft Fabric that I think could be improved is the potential confusion when working with real-time data versus normal batch loading."
"Snowpipe auto-ingest should be automatic."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"It is not that friendly with relational structures."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"The solution needs to offer more functionality related to machine learning and artificial intelligence."
"Their UiPath, the workspace area, needs some work."
 

Pricing and Cost Advice

Information not available
"I have worked with multiple clouds, and cost-wise, it is a bit costlier than others, such as Redshift. Its price should be reduced."
"Comparing Snowflake to on-prem options such as Oracle or SAP, it seemed more cost-effective."
"It is hard to say because we're usually engaged in the transition as opposed to the long term. Their storage costs are easily within pennies of what AWS S3 would normally cost. Most of the clients I've been working with are in the financial sector, and they're relatively small. I would put them in an SMB connection. The first thing we have to bring up for people is that they're going to build this. They shouldn't store their data in S3. They should pipeline directly into Snowflake and use it on their storage. So, the cost is a big issue because these are small to medium size companies, and that is the biggest thing we had to price point for them."
"There is a licensing for this solution and we purchased an enterprise license. Overall the solution is cost-effective."
"The tool's pricing is based on the number of queries you want on your database. The cost is small. To get the tool's pricing, you can do the math based on the cost per query, which is $0.002. If you're running your queries frequently, your charges will be higher than running fewer queries."
"Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
"The pricing part is based on the computing and storage. The costs are different and then there are services costs as well."
"Snowflake is cost-effective. However, the cost can depend on how it's being used and how efficiently the code is written. If engineers don't write efficient code and usage is billed based on processing, it can become costly. If they write optimal code and choose the best solution, it can reduce costs in comparison to other options, such as Oracle."
report
Use our free recommendation engine to learn which Data Management Platforms (DMP) solutions are best for your needs.
910,437 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
19%
Manufacturing Company
11%
Outsourcing Company
7%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business30
Midsize Enterprise20
Large Enterprise61
 

Questions from the Community

What needs improvement with Microsoft Fabric?
I think Microsoft Fabric can be improved, but I feel that everything is adequate. Everything is acceptable regarding the needed improvements.
What is your primary use case for Microsoft Fabric?
My main use case for Microsoft Fabric is data engineering. A specific example of something my team has used Microsoft Fabric for is to collect information from many sources and put it in the data w...
What advice do you have for others considering Microsoft Fabric?
My advice to others looking into using Microsoft Fabric is that it is a good solution. I heard from the cloud infrastructure team about this product. I do not have any additional thoughts about Mic...
What is your experience regarding pricing and costs for Snowflake?
I am not the person who manages pricing, setup cost, and licensing. Our team is not limited in pricing. The only experience we have had in terms of running and reprocessing a large number of histor...
What needs improvement with Snowflake?
One main area for improvement in Snowflake is cost visibility and optimization; while it's flexible and scalable, costs can increase quickly if warehouses are left running unnecessarily or workload...
What is your primary use case for Snowflake?
As a Data Engineer, I primarily use Snowflake for data warehousing tasks as well as ETL processing, and sometimes I also use it for data sharing. I personally find Snowflake better than other tools...
 

Also Known As

No data available
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Information Not Available
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Palantir, Informatica, Cloudera and others in Data Management Platforms (DMP). Updated: August 2026.
910,437 professionals have used our research since 2012.