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.
"Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across."
"One central workspace to manage everything for your data warehouse including visualization."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"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."
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on."
"They are available on the Cloud, and the platform is very intuitive."
"We can have the dedicated SQL up and running within 15 minutes."
"The most valuable feature is performance gains."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"The solution is very easy to use."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"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."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"The solution is easy to use."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"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 product could be more feature-rich."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"It's a complicated product."
"The cost of the solution has room for improvement."
"While the solution is flexible, sometimes this works against the user."
"The solution should offer a serverless model like Snowflake."
"It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a loop that is running all night, you could receive a very expensive bill."
"It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
"Snowflake needs transparency over costs and pricing."
"They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in."
"Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market."
"The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."
"The solution needs more connectors."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Snowflake is rated 8.4. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". 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 Azure Data Factory, SAP BW4HANA, Oracle Autonomous Data Warehouse, Teradata and Amazon Redshift, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and SAP BW4HANA. See our Microsoft Azure Synapse Analytics vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors and best 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.