We just raised a $30M Series A: Read our story

Compare Amazon Redshift vs. Microsoft Azure Synapse Analytics

Cancel
You must select at least 2 products to compare!
Comparison Summary
Question: How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Answer: Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different databases. It scales very easily and has a good cost-benefit ratio. It is very powerful and performs well. The data processing is very fast and can do analytics on the fly. Amazon Redshift should have more cloud-native tools that integrate with it as Microsoft does with the Azure ecosystem. There is some missing functionality that can make Redshift difficult to work in. If you are analyzing a lot of data, the load performance-wise can be very low. Microsoft Azure Synapse Analytics can handle large amounts of data - in the petabyte range. You can scale up and down as much as you want. It has a pay-as-you-go protocol, so you only pay for what you use. The speed is very good and the architecture is excellent. You are in control of what you need, which is a huge advantage. Microsoft Azure Synapse Analytics can be a very complicated product to use. The setup can be very complex. We had some issues with dashboard reporting - we found there were bugs in the platform when dealing with specific types of queries. This solution did not meet the necessary security protocols for some of our clients. Conclusion Both of these solutions are very stable, scalable, and flexible. Each of these products has their own unique ecosystems that are very competitive with each other, making them both great solutions to use. Although they are very similar, there are some features and functionalities that make them unique and attractive depending on the type of enterprise you operate. We are a smaller enterprise and overall our team felt based on ease of use, support, and where we are headed, we have started to migrate everything over to an AWS ecosystem and chose Amazon Redshift. It is the solution our clients liked best as well.
Featured Review
Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: November 2021.
555,139 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"The processing of data is very fast.""I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing.""Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features.""It is quite simple to use and there are no issues with creating the tables.""This service can merge and integrate well with all databases.""The most valuable feature is the scalability, as it grows according to our needs.""The feature that we find most useful is the ability to do analytics on the fly.""In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."

More Amazon Redshift Pros »

"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.""The architecture, including compute and storage, is good.""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.""We have found that it is easy to develop and to do the analytics in the modules of data.""The speed is great and the architecture is excellent.""The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems.""Overall deployment and integration is pretty fast.""It's user-friendly and has a good dashboard."

More Microsoft Azure Synapse Analytics Pros »

Cons
"Planting is the primary key enforcement that should be improved.""Amazon should provide more cloud-native tools that can integrate with Redshift like Microsoft's development tools for Azure.""Pricing is one of the things that it could improve. It should be more competitive.""There are too many limitations with respect to concurrency.""It would be useful to have an option where all of the data can be queried at once and then have the result shown.""In our experiments, the handling of unstructured data was not very smooth.""We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues.""It takes a lot of time to ingest and update the data."

More Amazon Redshift Cons »

"Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory.""I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.""The initial setup has a bit of a learning curve.""In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks.""It's a complicated product.""With respect to what needs to be improved, concurrent connectivity has some limitations.""This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query.""They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."

More Microsoft Azure Synapse Analytics Cons »

Pricing and Cost Advice
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company.""The part that I like best is that you only pay for what you are using.""The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price.""My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."

More Amazon Redshift Pricing and Cost Advice »

"Very costly solution and other products are available for less.""We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month.""There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be.""It goes by the usage, and there are some limits. Synapse goes by particular pricing, and it is expensive. Both Azure Synapse Analytics and Snowflake are pretty expensive. They don't have standard pricing. They deal with each customer differently.""When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.""It's very difficult to price unless you know exactly how the customer is using it.""The solution is subscription-based. You can also pay to use the product as you go.""Because it's cloud the cost is a different convention and the licensing costs are not the same."

More Microsoft Azure Synapse Analytics Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
555,139 professionals have used our research since 2012.
Questions from the Community
Top Answer: Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
Top Answer: Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features.
Top Answer: Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
Top Answer: The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is… more »
Top Answer: We are on a monthly payment plan for the use of Microsoft Azure Synapse Analytics.
Ranking
4th
Views
12,405
Comparisons
9,577
Reviews
12
Average Words per Review
509
Rating
7.7
2nd
Views
26,469
Comparisons
19,512
Reviews
34
Average Words per Review
537
Rating
7.9
Comparisons
Also Known As
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Learn More
Overview

Amazon Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. Customers can start small for just $0.25 per hour with no commitments or upfront costs and scale to a petabyte or more for $1,000 per terabyte per year, less than a tenth of most other data warehousing solutions.

Traditional data warehouses require significant time and resource to administer, especially for large datasets. In addition, the financial cost associated with building, maintaining, and growing self-managed, on-premise data warehouses is very high. Amazon Redshift not only significantly lowers the cost of a data warehouse, but also makes it easy to analyze large amounts of data very quickly.

Amazon Redshift gives you fast querying capabilities over structured data using familiar SQL-based clients and business intelligence (BI) tools using standard ODBC and JDBC connections. Queries are distributed and parallelized across multiple physical resources. You can easily scale an Amazon Redshift data warehouse up or down with a few clicks in the AWS Management Console or with a single API call. Amazon Redshift automatically patches and backs up your data warehouse, storing the backups for a user-defined retention period. Amazon Redshift uses replication and continuous backups to enhance availability and improve data durability and can automatically recover from component and node failures. In addition, Amazon Redshift supports Amazon Virtual Private Cloud (Amazon VPC), SSL, AES-256 encryption and Hardware Security Modules (HSMs) to protect your data in transit and at rest.

As with all Amazon Web Services, there are no up-front investments required, and you pay only for the resources you use. Amazon Redshift lets you pay as you go. You can even try Amazon Redshift for free.

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

Offer
Learn more about Amazon Redshift
Learn more about Microsoft Azure Synapse Analytics
Sample Customers
Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Top Industries
REVIEWERS
Comms Service Provider31%
Retailer23%
Logistics Company15%
Recruiting/Hr Firm8%
VISITORS READING REVIEWS
Computer Software Company29%
Comms Service Provider13%
Media Company10%
Financial Services Firm8%
REVIEWERS
Comms Service Provider18%
Computer Software Company18%
Manufacturing Company12%
Financial Services Firm12%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider18%
Financial Services Firm6%
Energy/Utilities Company6%
Company Size
REVIEWERS
Small Business29%
Midsize Enterprise35%
Large Enterprise35%
REVIEWERS
Small Business32%
Midsize Enterprise23%
Large Enterprise45%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise13%
Large Enterprise72%
Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: November 2021.
555,139 professionals have used our research since 2012.

Amazon Redshift is ranked 4th in Cloud Data Warehouse with 12 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 35 reviews. Amazon Redshift is rated 7.6, while Microsoft Azure Synapse Analytics is rated 8.0. The top reviewer of Amazon Redshift writes "Scales according to our needs, which saves a lot in terms of upfront costs". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". Amazon Redshift is most compared with Snowflake, Oracle Exadata, Teradata, Vertica and Oracle Autonomous Data Warehouse, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, SAP BW4HANA, Apache Hadoop, Oracle Autonomous Data Warehouse and Microsoft Parallel Data Warehouse. See our Amazon Redshift vs. Microsoft Azure Synapse Analytics report.

See our list of best Cloud Data Warehouse vendors and best 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.