We performed a comparison between Microsoft Azure Synapse Analytics and Snowflake Analytics based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Synapse Analytics' best feature is its ability to process large files."
"Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path."
"Fills the gap between big data and classic data warehouses."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"It's scalable; you can scale up and scale down."
"The most important feature for me is the integration with PolyBase."
"This is a stable solution with many functionalities."
"The product is easy to use, and anybody can easily migrate to advanced DB."
"I am impressed with the product's data-sharing feature."
"It can run complex workloads with varied compute."
"It ensures the optimization of the application development while maintaining the user-friendly nature of its UI."
"Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake."
"The platform not only provides ease of use but also stands out for its speedy execution, conveying a sense of robustness and reliability that I find appealing."
"The Snowflake features I find most beneficial for data analysis are primarily related to analytics, particularly their features like materialized views and queues, which are especially useful for dashboarding purposes."
"It is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning."
"Very good flexibility and it offers computation completely decoupled from the storage."
"I would like to see version control implemented into the data warehouse."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"It could be more stable."
"The solution should offer a serverless model like Snowflake."
"The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications."
"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."
"Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks."
"Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable."
"Snowflake's Snowpark is an area of concern where improvements are required."
"Snowflake could improve in the areas of advanced machine learning AML and generative AI."
"Implementing everything on-premise is challenging because it require proper support from advisors, DBAs, and others."
"The platform's data governance space needs more capability."
"Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake."
"The technical support is not very good."
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 Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Snowflake Analytics 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 Analytics writes "A scalable tool useful for data lake and data mining processes". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our Microsoft Azure Synapse Analytics vs. Snowflake Analytics 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.