All Amazon Redshift Reviews
1-14 of 14 Reviews
Sort by
Yanick
Verified reviewer
Food & Beverages, 2-10 employees
Used daily for less than 2 years
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
4
FUNCTIONALITY
5
Reviewed June 2022
Best Selection...
What's special about Amazon Redshift is that it constantly offers new features to meet the demands of increasingly large data stores. It is undoubtedly the best solution for data storage and processing in the cloud. If you are not yet a user, I highly recommend it.
CONSIt takes time to get up to speed with all the features of Amazon Redshift.
Anonymous
201-500 employees
Used daily for more than 2 years
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
4
FUNCTIONALITY
4
Reviewed April 2022
Reliable and easy to set up
Redshift has given us a viable OLAP data warehouse which speeds up all of our analytical workloads. The main benefits we got are speed, ease of use, and reliability, which in turn gave us more time to work on other projects and also much better visibility of our products and business.
PROSRedshift is a reliable cloud data warehouse that's easy to set up especially if your tech infra already runs on AWS.
CONSScaling out/up/down is quite limited with Redshift. The elastic resize is supposed to help on this but it's still limited to just halving/doubling your current cluster. It's not as flexible as Snowflake or BigQuery. Also, the max concurrency of 50 is quite low compared to other cloud data warehouses.
Reason for choosing Amazon Redshift
Redshift's pricing is straightforward and more predictable compared to other cloud data warehouses. Also, our existing tech infrastructure already runs on AWS so using Redshift gave us much better integration with our current tech stack.
Reasons for switching to Amazon Redshift
Our datasets are getting larger and larger. We needed an OLAP database which was more appropriate for our reporting and analytics workloads.
Gordon
Health, Wellness and Fitness, 201-500 employees
Used daily for more than 2 years
OVERALL RATING:
3
EASE OF USE
5
VALUE FOR MONEY
3
CUSTOMER SUPPORT
4
FUNCTIONALITY
3
Reviewed March 2024
Amazon Redshift - Average product
In my Opinion AWS redshift is an average product, the syntax and methods you have to use if you are used to using SQL server you will find to be more long winded or searching for alternatives ways. Basic items like parameters in stored procedures after a lot more complex than required.
PROSIt is a good tool for combining multiple data sources into one place. It is not really useful to load data in a delta approach but to fully reload the data source.
CONSIts ETL process always wants you to create objects as S3 objects which most of the time is fine but you then end up storing the data twice, once in the 3s and then again in Redshift unless you code to delete the S3 files after loading.
Craig
Verified reviewer
Marketing and Advertising, 1,001-5,000 employees
Used daily for less than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
4
FUNCTIONALITY
5
Reviewed May 2022
Solid, Reliable Option for Warehouse Storage
Redshift is the bedrock upon which our entire product lives. It stores the underlying data for our reporting, dashboards, etc.
PROSRedshift is a great starting point for storing data if you're planning to build out a stack using other AWS products (EMR clusters, S3 for browsing, etc.). Redshift is reliable/dependable, we haven't faced uptime issues or anything like that. Easy to query against which is essential for us when pulling reports or performing QA. In previous work I've also been able to hook Redshift up directly to Tableau which has been huge in building ad-hoc reporting directly from our datastore.
CONSIntegrations aren't always as intuitive as with other tools, but this can be avoided with a solid internal knowledge base.
Filippo
Verified reviewer
Marketing and Advertising, 51-200 employees
Used weekly for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
4
FUNCTIONALITY
5
Reviewed October 2023
A must-have tool for data warehousing
Amazon Redshift helped us creating standard reports for advertising activities and proved to be a valuable data source for our visual dahsboards
PROSAmazon Redshift allowed us to organize efficiently all our data, both for reporting and visualization purposes. You can use SQL syntax to query the tables and to extract all the info you need. It supports multiple datatypes with many data compression solutions to save disk space and money. The Amazon Redshift console (on the AWS dashboard) allows you to keep track of your db performances, from query execution time to disk space used, and displays also wise recommendation on how to manage properly your tables.
CONSThere is nothing I can complain about Amazon Redshift.
Anonymous
5,001-10,000 employees
Used daily for less than 2 years
OVERALL RATING:
4
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
4
FUNCTIONALITY
4
Reviewed February 2023
Amazon Redshift - Perfect database to build enterprise data warehouses !
Overall the Redshift experience is great and it can be used build your data warehouses.
PROSThe Redshift provided various data connector to get data from different sources . The data distribution can be defined while creating a table , which helps the SQL query to minimize the i/o operations , which intern increases the speed of the reports .
CONSThe redshift data distribution in disk is difficult at times to decide when you are build large data warehouses . The rival product like snowflake make it easy for the users as all of the data distributions are being taken care internally.
Anonymous
51-200 employees
Used daily for less than 6 months
OVERALL RATING:
3
EASE OF USE
2
VALUE FOR MONEY
3
CUSTOMER SUPPORT
1
FUNCTIONALITY
3
Reviewed April 2022
Works well, but not modern enough
I was satisfied with Amazon Redshift. It works fairly well, but ultimately competitors had a better offer, regarding features, scailing and pricing flexibility, and that is why we moved away from it.
PROSRedshift was surprisingly easy to deploy as a total begginer. Once it was up, it was always very stable and we didn't have any issues.
CONSRedshift is very much behind its competitors in offering better features for administrators. Its permission structure is ancient (comparing to Snowflake roles) and you're completely on your own for taking care of safety. As expected, we don't have consumer support and no account manager has ever contacted me.
Reason for choosing Amazon Redshift
Our company uses AWS stack, so i didn't look too much into GCP. But colleagues have said to me it would have been a better choice.
Iulian
Information Technology and Services, 5,001-10,000 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed August 2022
Works well, scales extremely well
Easy to use, fast query speed, highly scalable, robust security and easy to upload data via AWS. Pricing is fair.
CONSTable configuration process can be improved to make things easier.
Ryan
Verified reviewer
E-Learning, 1,001-5,000 employees
Used weekly for less than 12 months
OVERALL RATING:
5
EASE OF USE
3
VALUE FOR MONEY
3
FUNCTIONALITY
3
Reviewed June 2022
Redshift is great but really expensive
Mostly positive once it is set up but the set up can be extremely challenging
PROSI like that it was accessible across multiple devices and I like that it was possible to integrate with RStudio. That being said, sometimes my connections would just break if I didn't have the most up to date jar file and it was sometimes hard to figure out which jar file was the right one for the new version.
CONSAt times, my ODBC connections would just break or give weird errors and after hours of scrolling through the documentation, I am still confused
Anonymous
201-500 employees
Used weekly for less than 12 months
OVERALL RATING:
5
EASE OF USE
4
VALUE FOR MONEY
4
CUSTOMER SUPPORT
4
FUNCTIONALITY
4
Reviewed December 2022
Enter into the Dataverse
The speed, reliability, and ease of use are top of mind. The setup makes it easier for developers to specify priority and rules around processes and queries, also AI-powered capabilities in the background can be an enormous aid.
CONSThe complexity of documentation, which is huge, and it can be challenging to find a specific answer).
David
Verified reviewer
Information Technology and Services, 51-200 employees
Used weekly for more than 2 years
OVERALL RATING:
4
EASE OF USE
3
VALUE FOR MONEY
3
CUSTOMER SUPPORT
3
FUNCTIONALITY
3
Reviewed April 2022
Possibly powerful AWS database, but not the greatest UX
I like that Redshift is integrated with AWS and able to work with many AWS items, such as S3 buckets, and that it uses IAM for security. There's also a good range of AWS documentation, so in that regard, if you're an AWS environment it offers a lot of integration.
CONSRedshift's UX leaves something to be desired. It has a query editor, and now a V2 query editor, but they're not awesome interfaces. Also some things you want to schedule you can only do if you create a Python-based AWS lambda rather than being able to do in Redshift itself - and even then you need to statically import a Python PostgreSQL library to connect to Redshift. It's all kind of disjointed.
Anonymous
51-200 employees
Used daily for more than 2 years
OVERALL RATING:
5
EASE OF USE
5
VALUE FOR MONEY
5
CUSTOMER SUPPORT
5
FUNCTIONALITY
5
Reviewed February 2023
Buenísimo DWH
El rendimiento sin ningun tipo de duda, es potentísimo.
CONSque no tenga un cliente de administración a la altura
Anonymous
10,000+ employees
Used daily for less than 12 months
OVERALL RATING:
4
EASE OF USE
4
FUNCTIONALITY
4
Reviewed December 2022
SQLサーバーに慣れている運用者であれば好ましいツール
他のAWS製品だけでなく、ニッチな製品を含む多くのツールとデータのやり取りを行うことができる。
CONSSQL言語をベースとしたコードなので、複雑なETLが必要な場合、コードが不要に長くなってしまったり、分かりにくく書かなければならない時がある。2022年初めにPIVOT関数が導入されたりと柔軟性は高まってきているものの、ループ処理など含め、やはり他のETLツールと比べると開発しづらい面がある。
Reason for choosing Amazon Redshift
アウトプットを特定のBIツールと連携する必要があったため。
Anonymous
201-500 employees
Used weekly for more than 2 years
OVERALL RATING:
4
EASE OF USE
1
VALUE FOR MONEY
3
FUNCTIONALITY
4
Reviewed November 2022
Good DataWarehouse
Redshift is a good data warehouse, if you have a good devops teams, it follows the rules of AWS so the setup good be ok.
CONSDifficult to optmize, it could become quite expensive, and you need specialist if you want to use it well