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."
"The most valuable feature is the scalability, as it grows according to our needs."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"Redshift has an advantage when it comes to administration, making it easier to manage and collaborate."
"Changing from local servers to the cloud is very easy. It's so nice not to have to worry about physical servers."
"The feature that we find most useful is the ability to do analytics on the fly."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"It allows for the storage of huge amounts of data."
"It's feature-rich. It has a wide range of features."
"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."
"Synapse Analytics gives you information and reports in real-time."
"The architecture, including compute and storage, is good."
"Synapse Analytics' best feature is its ability to process large files."
"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."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"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."
"The initial deployment was complex."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The customer support could be more responsive."
"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."
"The solution could improve in handling more data formats and more native support for RDF."
"Amazon Redshift could improve the user interface support."
"We are using third-party tools to integrate Amazon Redshift, they should create their own interface on their own for it to be easily connected on the AWS itself."
"I would like to see version control implemented into the data warehouse."
"While the solution is flexible, sometimes this works against the user."
"Could have more connectors and better integration for Hadoop."
"We'd, of course, always like to pay less for the service if we can."
"The initial setup is complex."
"This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 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 Snowflake, Teradata, AWS Lake Formation, 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.