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.
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The feature that we find most useful is the ability to do analytics on the fly."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"This service can merge and integrate well with all databases."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The solution is scalable. It handles different loads very well."
"It's scalable because it's on the cloud."
"The product offers good support for the data lake."
"I have not used the technical support from Microsoft Azure Synapse Analytics, but I worked with the developers at Microsoft who were top-notch."
"The stability is pretty good."
"It's user-friendly and has a good dashboard."
"The most advantageous aspect of Microsoft Azure Synapse Analytics is its simplified data transformation process compared to traditional databases. This makes data cleansing and transformation more manageable and straightforward, which we appreciate. It is much easier to build as well."
"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."
"The pricing seems to be quite fair."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"The solution handles single or complex items within a second."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The OLAP slide and dice features need to be improved."
"The solution could improve in handling more data formats and more native support for RDF."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"I would like to improve the pricing and the simplicity of using this solution."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Amazon Redshift is a little more expensive than other products."
"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."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"I would like my team to be able to build pipelines that integrate with the Azure Data Factory."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"Integration with other vendors has limitations and could be improved."
"Integration with other products is an area that can be improved."
"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."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 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 Teradata, Vertica, Snowflake, AWS Lake Formation 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.