Compare Amazon Redshift vs. Microsoft Azure Synapse Analytics

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: November 2020.
448,076 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
"It allows you write complex queries and perform row by row processes.""It allows for the storage of huge amounts of data.""The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it.""The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing.""The initial setup of this solution is straightforward.""The product is relatively easy to use because there is no indexing and no partitions.""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.""The processing of data is very fast."

More Amazon Redshift Pros »

"Scaling this solution is easy and the uptime is okay.""The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS.""The initial setup was really easy and straightforward.""The MPP (Massively Parallel Processing) architecture helps to make things a lot faster.""The most valuable feature is the scalability.""The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range.""The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs.""Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to."

More Microsoft Azure Synapse Analytics Pros »

Cons
"In the next release, a pivot function would be a big help. It could save a lot of time creating a query or process to handle operations.""Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions.""The speed of the solution and its portability needs improvement.""Running parallel queries results in poor performance and this needs to be improved.""The product could be improved by making it more flexible.""Pricing is one of the things that it could improve. It should be more competitive.""It would be useful to have an option where all of the data can be queried at once and then have the result shown.""It takes a lot of time to ingest and update the data."

More Amazon Redshift Cons »

"I would like to see better integration with Active Directory, because we have had problems, and we still do.""The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster.""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.""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.""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.""With respect to what needs to be improved, concurrent connectivity has some limitations.""I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it.""The configuration for things like high-availability could be more user-friendly for non-technical users."

More Microsoft Azure Synapse Analytics Cons »

Pricing and Cost Advice
"It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20.""The best part about this solution is the cost.""The part that I like best is that you only pay for what you are using.""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.""At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."

More Amazon Redshift Pricing and Cost Advice »

"The price of this solution could be improved.""The pricing is okay. You can pay as you go.""This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version.""When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.""The licensing fees for this solution are on a pay-per-use basis, and not very expensive.""All of the prices are available online.""Our license is very expensive""They are cost aggressive, and it integrates well with other Microsoft tools."

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.
448,076 professionals have used our research since 2012.
Questions from the Community
Top Answer: The processing of data is very fast.
Top Answer: Of course I would advise others to choose Amazon Redshift, as long as pricing is not a concern for them.
Top Answer: It would be useful to have an option where all of the data can be queried at once and then have the result shown. As it is now, when we run a query and we are looking at the results, part of the data… more »
Top Answer: The most valuable feature of the solution is the analytics and that it can connect with Power BI.
Top Answer: The licensing fees for this solution are on a pay-per-use basis, and not very expensive.
Ranking
3rd
Views
13,836
Comparisons
9,798
Reviews
11
Average Words per Review
483
Avg. Rating
7.6
2nd
Views
13,064
Comparisons
10,722
Reviews
20
Average Words per Review
546
Avg. Rating
7.9
Popular Comparisons
Compared 20% of the time.
Compared 14% of the time.
Compared 14% of the time.
Also Known As
Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse
Learn
Amazon
Microsoft
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 449Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Top Industries
REVIEWERS
Comms Service Provider36%
Logistics Company18%
Manufacturing Company9%
Retailer9%
VISITORS READING REVIEWS
Computer Software Company38%
Media Company15%
Comms Service Provider10%
Financial Services Firm4%
REVIEWERS
Manufacturing Company22%
Computer Software Company22%
Transportation Company11%
Comms Service Provider11%
VISITORS READING REVIEWS
Computer Software Company39%
Comms Service Provider14%
Media Company5%
Financial Services Firm4%
Company Size
REVIEWERS
Small Business25%
Midsize Enterprise43%
Large Enterprise32%
REVIEWERS
Small Business29%
Midsize Enterprise25%
Large Enterprise46%
Find out what your peers are saying about Amazon Redshift vs. Microsoft Azure Synapse Analytics and other solutions. Updated: November 2020.
448,076 professionals have used our research since 2012.

Amazon Redshift is ranked 3rd in Cloud Data Warehouse with 11 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 20 reviews. Amazon Redshift is rated 7.6, while Microsoft Azure Synapse Analytics is rated 7.8. 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, Teradata, Oracle Exadata, Oracle Autonomous Data Warehouse and VMware Tanzu Greenplum, whereas Microsoft Azure Synapse Analytics is most compared with Snowflake, Oracle Autonomous Data Warehouse, SAP BW4HANA, Oracle Exadata 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.