We performed a comparison between Amazon Redshift and Microsoft Azure Synapse Analytics based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Amazon Redshift comes out on top in this comparison. It is easy to use and performs well. In addition Amazon Redshift is easier to set up than Microsoft Azure Synapse Analytics.
"The most valuable feature is its scalability."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"The product is relatively easy to use because there is no indexing and no partitions."
"This service can merge and integrate well with all databases."
"The product offers good support for the data lake."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"The most valuable feature of Redshift is its cluster."
"I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"They are very reliable and cost-effective."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"Synapse Analytics gives you information and reports in real-time."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"Very interactive and provides flexibility."
"The most valuable features of Microsoft Azure Synapse Analytics are its serverless flexibility and complete power have allowed me to explore various different use cases. While I am not an expert in the product, my experience in programming in Databricks has shown me that Microsoft's investments in Synapse could potentially lead to it becoming a complete replacement for Databricks in the future."
"Improvement could be made in the area of streaming data."
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure."
"The explain panel in the Redshift database could be better."
"There are physically too many pipelines for a company of this size to maintain. For a data scientist, it's very difficult to learn the data in all of these different environments."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster."
"I would like to see version control implemented into the data warehouse."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
"Integration with other products is an area that can be improved."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"We'd like the solution to have more analytics capability."
"One area that could be improved is the schema management."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews. Amazon Redshift is rated 7.8, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Oracle Exadata, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Apache Hadoop. See our Amazon Redshift vs. Microsoft Azure Synapse 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.