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) (5th), AI Software Development (8th)
 

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 features and capabilities of Microsoft Fabric that I have found most useful include it being a uniform platform."
"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 Mbps they have established is quite a bit faster than any other data warehouse."
"Snowflake solves many of the challenges that traditional data warehousing tools have such as a lack of agility, scalability and fine-tuning."
"Snowflake has improved my organization because of its high performance compared to the old way we used to operate with Microsoft SQL Server."
"The most valuable feature of Snowflake is the query performance."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"The solution's customer service is good."
"The querying speed is fast."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
 

Cons

"I think the Copilot usage in Microsoft Fabric can be improved."
"In my experience, Microsoft Fabric is not stable."
"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."
"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 workloads are not monitored carefully, raising the costs of the tool."
"We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"Getting data out of the tool to third-party applications is difficult."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point."
"Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety."
"Some SQL language functions could be included."
"The cost of the solution could be reduced."
 

Pricing and Cost Advice

Information not available
"There is a license needed to use this solution. There are a few licensing options available. They have a pay-as-you-go option, but it is recommended to pay upfront."
"The pricing for Snowflake is competitive."
"Part of the problem with the pricing is that it is very difficult for businesses to get an idea of how expensive it might be until they actually start using Snowflake."
"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."
"Snowflake is a cost-effective solution."
"It is on a monthly basis. It is based on your usage. There are no additional costs from the point of the licensing fee. We do give some kind of evaluation to the customers about how much it is going to be. You can decide in Snowflake the virtual machine that you are using for customers. There are several kinds of virtual machines that you can use. It is similar to the clothing sizes: small to extra large. If you need more power in the coming month, you can decide in advance and take a more powerful machine. You can just select it from the platform. You can also decide which machine you want to take for extracting data."
"The pricing part is based on the computing and storage. The costs are different and then there are services costs as well."
"The solution is expensive but worth the cost because the quality is there."
report
Use our free recommendation engine to learn which Data Management Platforms (DMP) solutions are best for your needs.
903,067 professionals have used our research since 2012.
 

Top Industries

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

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: May 2026.
903,067 professionals have used our research since 2012.