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 features are that it's easy to set up and easy to connect the many tools that connect to it."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"The initial setup of this solution is straightforward."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"It's user-friendly and has a good dashboard."
"It is a highly stable solution and it's easy to use."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"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."
"It's feature-rich. It has a wide range of features."
"They are available on the Cloud, and the platform is very intuitive."
"They are very reliable and cost-effective."
"The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"Planting is the primary key enforcement that should be improved."
"Pricing is one of the things that it could improve. It should be more competitive."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Sometimes, it's difficult to get the metadata from Redshift."
"Non-structured data is unavailable with this product."
"The solution does not support oriented scaling in the synapse."
"The platform is not flexible, and the graphical user interface needs to be improved because the interface makes it hard for the end user to use it."
"The product could be more feature-rich."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft."
"The product needs a tool that allows for work from a laptop instead of a browser."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
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.