Amazon Redshift

Amazon Redshift

213 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Amazon Redshift	Score9 out of 10	N/A	Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.	$0.24 per GB per month

Pricing

Amazon Redshift

Redshift Managed Storage: $0.24
per GB per month
Current Generation: $0.25 - $13.04
per hour
Previous Generation: $0.25 - $4.08
per hour
Redshift Spectrum: $5.00
per terabyte of data scanned

Pricing Offerings
Amazon Redshift
Free Trial
No
Free/Freemium Version
No
Premium Consulting/Integration Services
No

No setup fee

—

Community Pulse
Key User Insights
	Amazon Redshift
Considered Both Products	Amazon AWS Verified User Chose Amazon Redshift Amazon Redshifts has fewer features but at the same time, you also have some gains once it is running on AWS Cloud and it is really easy to set up. Besides that, in our case, it is a bit cheaper and we don't really need the extra features that you can find on Snowflake. Another … Incentivized Helpful? Verified User Chose Amazon Redshift Amazon Redshift, BigQuery, and Snowflake are all fully managed data warehouse services that are designed to handle large volumes of structured data and support business intelligence and analytics efforts. However, Amazon Redshift has the upper hand with its cost-effective … Incentivized Helpful? Dileep Kumar Principal Data Scientist in Research & Development at RudderStack (Computer Software, 51-200 employees) Chose Amazon Redshift Biggest advantage of Amazon Redshift is it's part of the aws ecosystem. When tuned well it is also very cheap compared to something like Snowflake. And compared to spark or databricks, Amazon Redshift is a solid warehouse that's well suited for tabular data. We use it for user … Incentivized Helpful? Narayan Motamarri Staff Data Engineer in Engineering at Hearst Autos (Marketing & Advertising, 501-1000 employees) Chose Amazon Redshift We evaluated [Amazon] Redshift vs BigQuery vs Amazon EMR, back in 2014. Back then BigQuery cost was slightly higher than that of [Amazon] Redshift price structure. Amazon EMR, needs lots more management (Admin tasks) and EMR is designed to be ephemeral and not designed to be a … Incentivized Helpful? Prashast Vaish Decision Scientist in Information Technology at Mu Sigma Inc. (Information Technology & Services, 1001-5000 employees) Chose Amazon Redshift Redshift is better cost wise and also since the whole ecosystem is set in AWS, it is wise to use redshift Incentivized Helpful? Verified User Chose Amazon Redshift Redshift leapfrogged Hive back when Hive was trying to figure out how to implement indexes, providing a more stable, standardized (postgres), easy to use (any postgres client), easier to administer, and scalable solution for querying server logs and raw usage data. Now, Snowflak… Incentivized Helpful? Verified User Chose Amazon Redshift Amazon Redshift is one of the fastest service offerings available in the market now. Plus you get an advantage of using a cutting edge compute service offering from AWS. Other technologies are fast but not as good as Amazon Redshift, I would say. Our business is interested in … Incentivized Helpful? Bojan Sovilj 1st walker in Corporate at Cloudwalker d.o.o (Gambling & Casinos, 1-10 employees) Chose Amazon Redshift 1. Redshift has better compression (automated) consuming less space then competitors 2. Automated Vacuum Delete for having consistent performance 3. AWS introduced ra3 node types for simple separation of compute and storage Incentivized Helpful? Duncan Hernandez Sr. Analyst, Business Intelligence in Product Management at Age of Learning, Inc. / ABCmouse.com (E-Learning, 201-500 employees) Chose Amazon Redshift Its definitely an improvement on all fronts for our business needs. Again, our MySQL server was really slow and we needed a more efficient solution. It was a major upgrade, but it is much more expensive than an in house server. It was expected but I'd say that lots of headaches … Incentivized Helpful? Verified User Chose Amazon Redshift Amazon Redshift supports multiple data formats including multiple structured data formats. And it is easy to implement a cluster if you do not have knowledge of data lake solution. Also when you do not need a lot of resources, you can just scale down so you do not have to spend … Incentivized Helpful? Verified User Chose Amazon Redshift The best advantage for us was the easy way to integrate our current solution in AWS to Amazon Redshift. Incentivized Helpful? Jay Padhya Data scientist in Corporate at FCA AUTOMOBILES (Automotive, 10,001+ employees) Chose Amazon Redshift Amazon Redshift has a better UI, hands down. And it is easy to integrate with bigger tools like Talend. It has many issues when it comes to understanding the architect perspective like Toad, which has a better UI for architect data together. However, that is because we are not … Incentivized Helpful? Verified User Chose Amazon Redshift We like Snowflake for its separation of computing and storage and also the separation of data warehouse different users. We replaced Redshift with Snowflake. However, Snowflake is great for its pay for performance kind of methodology. Incentivized Helpful? Arthur Zubarev Senior Business Intelligence Consultant in Information Technology at Sermo (Research, 201-500 employees) Chose Amazon Redshift Azure SQL Database was discarded because of a less attractive licensing, costs, plus its integrates poorly with many of the Azure offerings as say Azure Data Factory - it is not a true ETL yet. Also, the rest of the tools used were of Open Source type and it did not look like a … Incentivized Helpful? Verified User Chose Amazon Redshift The main reason we chose Redshift was because of the cost-effectiveness of running and maintaining the warehouse. Incentivized Helpful? Akshaya Bhardwaj Consultant in Information Technology at WNS Global Services (Outsourcing/Offshoring, 10,001+ employees) Chose Amazon Redshift It works on the cloud and we use the platform Dbeaver which is very unique and easy to maintain. There are very limited tools of this kind but the security issues are pretty high within those tools. Incentivized Helpful? Verified User Chose Amazon Redshift As our applications are hosted on AWS service, Redshift is the best option for us. Also, it provide a near to real-time performance on limited datasets and less complex queries. High availability is the major concern for any growing business and AWS is the best option for this. … Incentivized Helpful? Vibhakar Prasad Data Engineer Consultant in Information Technology at Intapp (Legal Services, 201-500 employees) Chose Amazon Redshift No comment on this. Incentivized Helpful? Verified User Chose Amazon Redshift We are currently on Redshift, because it was out before Snowflake. However, Snowflake looks promising. It's the new shiny toy that gives options that Redshift does not provide for. The big thing is that storage and compute can be scaled separately, whereas you cannot do that in … Incentivized Helpful? Verified User Chose Amazon Redshift Most of our stack is on AWS, so while Snowflake and BigQuery was a viable option from a performance perspective, it was easier to integrate with RedShift. We considered hosting SQL Server on AWS or using Amazon RDS (Postgres or MySQL), however, the self-service aspect of … Incentivized Helpful? Jacob Biguvu Database Engineer/DBA (Cloud and On-Premises) in Information Technology at Capital One (Financial Services, 10,001+ employees) Chose Amazon Redshift Snowflake supports semi-structured data types and provided solutions to manage/process the semi-structured data. It supported sharing data between the different accounts and makes it easy in the scale and scale down process. Snowflake doesn't limit users on the database. Incentivized Helpful? Verified User Chose Amazon Redshift Amazon Redshift is much easier to set up and start using. It interacts well with the PostgreSQL client (psql) and shares certain basic data dictionary, and people familiar with PostgreSQL feel right at home. The cluster is part of AWS services offering, and it works well with … Incentivized Helpful? Gavin Hackeling Data Scientist in Engineering at Wonder (AskWonder.com) (Research, 11-50 employees) Chose Amazon Redshift Some organizations use PostgreSQL as an OLAP store. PostgreSQL offers a modern SQL dialect, data types, and features that Redshift lacks. RDS is a great managed PostgreSQL product. However, PostgreSQL is a poor choice for a data warehouse. It's row-oriented storage requires … Incentivized Helpful?
	Would buy again
	No answers on this topic
	Delivers good value for the price
	No answers on this topic
	Happy with the feature set
	No answers on this topic
	Lived up to sales and marketing promises
	No answers on this topic
	Implementation went as expected
No answers on this topic

User Ratings
	Amazon Redshift
Likelihood to Recommend	9.0 (38 ratings)
Usability	9.0 (10 ratings)
Support Rating	9.0 (7 ratings)
Contract Terms and Pricing Model	10.0 (1 ratings)