We performed a comparison between Microsoft Azure Synapse Analytics and Snowflake based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Based on the parameters we compared, Snowflake had a better user rating regarding ease of deployment and pricing. Both softwares had the same rating when it came to service and support. In terms of features, Microsoft Azure Synapse Analytics users felt the software had security issues and didn’t feel it was very intuitive. In contrast, users of Snowflake felt the UI needed improvement.
"The useability, the user interface, is very user-friendly."
"Data can be stored any way you want in the data warehouse."
"The whole solution is interesting for us."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"The solution operates like a typical SQL Server environment so there is no alienation in terms of technical knowledge."
"They are very reliable and cost-effective."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"The solution is stable."
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"Microsoft Azure Synapse Analytics could improve the section in the solution where you can implement the Python Spark pipelines, it's not the same as in Databricks which would be better."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"Synapse Analytics is generally stable, but its performance can be slow when performing very large datasets."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"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."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"The solution could use a little bit more UI."
"There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm. The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical. The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"This solution could be improved by offering machine learning apps."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.
Microsoft Azure Synapse Analytics is built with these 4 components:
Microsoft Azure Synapse Analytics Features
Microsoft Azure Synapse Analytics has many valuable key features, including:
Microsoft Azure Synapse Analytics Benefits
Some of the benefits of using Microsoft Azure Synapse Analytics include:
Reviews from Real Users
Below are some reviews and helpful feedback written by Microsoft Azure Synapse Analytics users who are currently using the solution.
PeerSpot user Jael S., who is an Information Architect at Systems Analysis & Design Engineering, comments on her experience using the product, saying that it is “Scalable, intuitive, facilitates compliance and keeps your data secure”. She also says "We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."
Michel T., CHTO at Timp-iT, mentions that "the features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
A Senior Teradata Consultant at a tech services company says, "Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.
Its platform is made up of three components:
Snowflake has many valuable key features. Some of the most useful ones include:
There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.
Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
A Solution Architect at a wholesaler/distributor comments, "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."
Microsoft Azure Synapse Analytics is ranked 3rd in Cloud Data Warehouse with 48 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 49 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Snowflake is rated 8.4. The top reviewer of Microsoft Azure Synapse Analytics writes "Multifeatured, has better performance over other solutions, and lets users manage structured and unstructured information, but the platform needs to be more user-friendly". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Microsoft Azure Synapse Analytics is most compared with Amazon Redshift, Azure Data Factory, SAP BW4HANA, Apache Hadoop and AWS Lake Formation, whereas Snowflake is most compared with Teradata, Vertica, Azure Data Factory, Amazon Redshift and AWS Lake Formation. See our Microsoft Azure Synapse Analytics vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.