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 that the solution is fully embedded in the AWS stack."
"The most valuable feature of Redshift is its cluster."
"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."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"It is quite simple to use and there are no issues with creating the tables."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"You can copy JSON to the column and have it analyzed using simple functions."
"It is a fantastic product; we are satisfied with its features and performance."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"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 most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"It's scalable; you can scale up and scale down."
"The solution handles single or complex items within a second."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The solution could improve in handling more data formats and more native support for RDF."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"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."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"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."
"Planting is the primary key enforcement that should be improved."
"The support and price could improve."
"Microsoft Azure Synapse Analytics's overall integration within the Azure ecosystem could improve. The native Microsoft solution versus another solution, such as Databricks, there are areas where there could be some improvements."
"The product needs a tool that allows for work from a laptop instead of a browser."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"The initial setup has a bit of a learning curve."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
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.