--- title: Amazon Redshift Reviews meta_title: 'Amazon Redshift Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 403 reviews by the users' company size, role or industry to find out how Amazon Redshift works for a business like yours. aggregate_rating: rating_value: 4.3 review_count: 403 scale: '5' date_modified: '2026-07-14' parent_category: name: IT Infrastructure url: https://www.g2.com/categories/it-infrastructure --- # Amazon Redshift Reviews **Vendor:** Amazon Web Services (AWS) **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.3/5.0 **Total Reviews:** 403 ## About Amazon Redshift Tens of thousands of customers use Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions. ## Amazon Redshift Pros & Cons **What users like:** - Users praise the **fast querying** capabilities of Amazon Redshift, finding it efficient for handling large datasets seamlessly. (5 reviews) - Users highlight the **seamless integration** of Amazon Redshift with other software, enhancing data management and query performance. (5 reviews) - Users love the **ease of use** with Amazon Redshift, appreciating its user-friendly interface and efficient data management. (4 reviews) - Users appreciate the **easy integrations** of Amazon Redshift, enhancing their ability to build comprehensive data solutions. (4 reviews) - Users highlight the **impressive speed and scalability** of Amazon Redshift, making data handling efficient and flexible. (4 reviews) - Users appreciate the **scalability** of Amazon Redshift, enabling efficient handling of massive data volumes seamlessly. (4 reviews) - Features (3 reviews) - Users value the **efficiency in managing large datasets** with Amazon Redshift, making complex queries seamless and fast. (3 reviews) - Scaling (3 reviews) - Users value the **speed and efficiency** of Amazon Redshift, enhancing their ability to manage large datasets seamlessly. (3 reviews) **What users dislike:** - Users find **feature limitations** in Amazon Redshift, noting its lack of advanced analytics and cross-language support. (4 reviews) - Users find **software limitations** in Redshift, particularly regarding performance degradation and support for unstructured data. (4 reviews) - Users face **significant complexity** in managing Redshift, requiring substantial effort for optimization and maintenance. (3 reviews) - Users face **query issues** with Amazon Redshift, as performance tuning and concurrency management can be challenging. (3 reviews) - Users find **query optimization cumbersome** in Redshift, requiring significant time and effort for effective performance tuning. (3 reviews) - Difficult Management (2 reviews) - Expensive (2 reviews) - Integration Issues (2 reviews) - Learning Difficulty (2 reviews) - Performance Issues (2 reviews) ## Amazon Redshift Reviews ### 1. Amazon Redshift **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Online Media | Enterprise (> 1000 emp.) **Reviewed Date:** December 15, 2022 **What do you like best about Amazon Redshift?** Redshift features, performance and support. **What do you dislike about Amazon Redshift?** Pricing, initial adoption of the tool and documentation. **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehouse ### 2. It's been a great experience working with redshift as this is super fast **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Amazon Redshift?** MPP way of architecture means queries execute quickly matter how large the data is. **What do you dislike about Amazon Redshift?** Performance tunning is a bit headache this needs to be given some thought too as there is very less material available online **What problems is Amazon Redshift solving and how is that benefiting you?** Classic resize on which AWS just worked last week will help save lots of time ### 3. Best tool for data warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** veena k. | Research Scholar, Mid-Market (51-1000 emp.) **Reviewed Date:** July 04, 2022 **What do you like best about Amazon Redshift?** - it is easily scalable - very cost effective at low usage - very easy to use if you have used similar tools in the past **What do you dislike about Amazon Redshift?** Apart from requiring some training, I think there is not much to dislike about the tool. **What problems is Amazon Redshift solving and how is that benefiting you?** We are trying to build an in-house data warehousing solution and makenit cost effective. ### 4. Amazing learning experience **Rating:** 5.0/5.0 stars **Reviewed by:** Ritesh S. | Software Engineer 3, Enterprise (> 1000 emp.) **Reviewed Date:** July 17, 2022 **What do you like best about Amazon Redshift?** No downtime and user friendly. Its was my first time learning opportunity **What do you dislike about Amazon Redshift?** More learning content for new users to experience and adapt to new tech **What problems is Amazon Redshift solving and how is that benefiting you?** It helps my analyse my raw data into mean full charts, helps my in ETL and create a datawareshouse for easy slicing and dicing ### 5. Cloud based, petabyte scale data warehousing services **Rating:** 4.5/5.0 stars **Reviewed by:** Pravin K. | Operations Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Amazon Redshift?** Widely adopted, ideal for data lakes, performance, security, scalability **What do you dislike about Amazon Redshift?** Multi cloude solution should be there, serverless architecture should be there, choice of pricing and key impact performance **What problems is Amazon Redshift solving and how is that benefiting you?** Cloud native data warehousing technology is helping, support is there in organisation for extracting data from data warehousing. ### 6. It's a great database **Rating:** 5.0/5.0 stars **Reviewed by:** Sushant R. | Business Intelligence Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Amazon Redshift?** It's easy to fireup and start using, the best querying option on DWH, very fast and less administrative load. **What do you dislike about Amazon Redshift?** Why so late, now we have to move from legacy to new and the price. **What problems is Amazon Redshift solving and how is that benefiting you?** Apart from the storage and security the best thing is the ease of querying. ### 7. AWS Redshift Pioneer **Rating:** 4.5/5.0 stars **Reviewed by:** Sonu S. | Accounts Payable Associate, Enterprise (> 1000 emp.) **Reviewed Date:** March 15, 2022 **What do you like best about Amazon Redshift?** Its widely adopted, ideal for data lakes, security is excellent, querying is very easy and storage is columnar which is very unique and fast. Performance is at peak. **What do you dislike about Amazon Redshift?** pricing is a little more for redshift compare to other products and it's not ideal for all multi-cloud solutions and last everyone is dependent on the master node for execution. **Recommendations to others considering Amazon Redshift:** This is must use the product if you want your business to scale to all new heights. **What problems is Amazon Redshift solving and how is that benefiting you?** Data transformation and data storage is the best part where I am utilizing AWS redshift apart from day-to-day activity. Big data is becoming more valuable and redshift helps to make it easy. ### 8. Redshift Review **Rating:** 3.5/5.0 stars **Reviewed by:** Shivendra V. | Python dveloper, Small-Business (50 or fewer emp.) **Reviewed Date:** July 04, 2022 **What do you like best about Amazon Redshift?** Interface was good and query response was superfast. **What do you dislike about Amazon Redshift?** All was good with it. I did not find anything which I can dislike. **Recommendations to others considering Amazon Redshift:** If you are looking for faster response then redshift can be a good choice. **What problems is Amazon Redshift solving and how is that benefiting you?** In hive query response was more so for creating reports we using redshift. ### 9. Amazon Redshift Recommendation **Rating:** 4.0/5.0 stars **Reviewed by:** Jatin K. | Lead Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 06, 2022 **What do you like best about Amazon Redshift?** Its good for data warehousing processing **What do you dislike about Amazon Redshift?** Things break when we have large amount of data to be proccessed **Recommendations to others considering Amazon Redshift:** If you have large data to be processed then please use spark **What problems is Amazon Redshift solving and how is that benefiting you?** We are saving aggregates data into it to make it querable from BI tools ### 10. Powerful Data Management Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Mohit A. | Senior Data Scientist, Enterprise (> 1000 emp.) **Reviewed Date:** April 05, 2022 **What do you like best about Amazon Redshift?** -Works extremely well with AWS Backup system was extremely easy to use They were willing to discount on the price. -Uploading data into Redshift via AWS. -Querying is quick. **What do you dislike about Amazon Redshift?** JSON is difficult to use We were running complicated SQL and it struggled with it. Missing option to restrict duplicate records. lacks complex data sets like udf. **Recommendations to others considering Amazon Redshift:** Amazon Redshift, maybe the best option for a data warehouse. **What problems is Amazon Redshift solving and how is that benefiting you?** We use Amazon Redshift Spectrum as our Data Lake, where we store raw (unprocessed) data (Cold data) for historical analysis, trends, etc. ### 11. When you don’t need to do update operations . High vertical and horizontal performance. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** April 16, 2022 **What do you like best about Amazon Redshift?** The performance improvement over a period of time. We see improvement of vertical database performance over period of time and over growth of data.Other database such as oracle shows comparatively very low improvement using statistics and other factors. Primarily because of column based/row based differnce. **What do you dislike about Amazon Redshift?** Its not support merge operation that is upsert aka update and insert together. The without s3 copy the database is very slow to insert or update. I feel it's built to work in a certain way only. Because of maybe certain other reasons. **What problems is Amazon Redshift solving and how is that benefiting you?** Millions of data read for Tableau at faster rate and performance support for queries. High overhead operations of oracle bulk loader operations is brought down by high performance s3 copy operations. ### 12. Amazon Redshift Overview **Rating:** 4.0/5.0 stars **Reviewed by:** Saad Abdul R. | Manager, Data Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** July 15, 2022 **What do you like best about Amazon Redshift?** It's scalable because it's on the cloud. **What do you dislike about Amazon Redshift?** The refreshment rate of data reaching Redshift from other sources should be faster. **What problems is Amazon Redshift solving and how is that benefiting you?** The feature that we find most useful is the ability to do analytics on the fly. ### 13. Solid Data Warehouse **Rating:** 4.0/5.0 stars **Reviewed by:** Phong B. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 06, 2022 **What do you like best about Amazon Redshift?** Managed, Scalable very easy to deploy with just a few clicks. **What do you dislike about Amazon Redshift?** Had a bit of trouble integrating Redshift with dbt. Other than that, Redshift is a pretty solid data warehouse solution **What problems is Amazon Redshift solving and how is that benefiting you?** Analytics. Redshift is pretty fast for doing heavy queries ### 14. Redshift review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Amazon Redshift?** Great user experience, automated table designs, extensively used easy to query and connect with different applications. **What do you dislike about Amazon Redshift?** No way to enforce uniqueness in the data. No paralle upload. **What problems is Amazon Redshift solving and how is that benefiting you?** Best solution for analytical purpose and running faster queries. ### 15. Very handy in building etl applications **Rating:** 5.0/5.0 stars **Reviewed by:** Awinash S. | Lead Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2022 **What do you like best about Amazon Redshift?** Managebility and scalability and performance. **What do you dislike about Amazon Redshift?** Programming construct needs improvement. **What problems is Amazon Redshift solving and how is that benefiting you?** Reducing infra cost. Providing a fully manageable development suit where I can be focusing only on solving my business issues. ### 16. Everything well managed by the service itself. **Rating:** 4.5/5.0 stars **Reviewed by:** Rakesh M. | Big Data Enginer - Senior Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** July 15, 2022 **What do you like best about Amazon Redshift?** Deltalake to store and handle the data as a service. **What do you dislike about Amazon Redshift?** Nothing to dislike. More then that I can suggest one area for improvement. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift used to store the data for dashboard visualization. ### 17. Data Migration Oracle to Amazon Redshift **Rating:** 4.0/5.0 stars **Reviewed by:** Sameera D. | Senior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 05, 2022 **What do you like best about Amazon Redshift?** The data validation process is marvelous **What do you dislike about Amazon Redshift?** Everything is good. I was using this for integration purposes and done a very good job **What problems is Amazon Redshift solving and how is that benefiting you?** it help me to identify all the invalid and not supported items in the DB ### 18. Redshift: Powerful Data Warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Ravi M. | Application Development Assoc Manager, Enterprise (> 1000 emp.) **Reviewed Date:** July 21, 2022 **What do you like best about Amazon Redshift?** Distribution keys and Analyze operation **What do you dislike about Amazon Redshift?** Redshift Vaccum and not 100% managed services **What problems is Amazon Redshift solving and how is that benefiting you?** Greater ROI as it is 1/10th the cost of traditional data stores and data warehouse. ### 19. User friendly , will likely advise to use it **Rating:** 4.5/5.0 stars **Reviewed by:** Nitu P. | Associate Director, Small-Business (50 or fewer emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Amazon Redshift?** Ease of quering Performance Strong AWS based **What do you dislike about Amazon Redshift?** Price Not multi cloud based Not a serverless architecture **What problems is Amazon Redshift solving and how is that benefiting you?** Makes it possible to analyse and view all customer specif data ### 20. Scalable and fast data warehousing using Amazon Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Gaurav B. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2021 **What do you like best about Amazon Redshift?** It is fast, scalable, encrypted. It's the ability to distribute the data among multiple nodes based on a key. You never have to worry about creating indexes and resource optimization. **What do you dislike about Amazon Redshift?** I did not find anything to dislike about amazon redshift. It is getting better every new release. **Recommendations to others considering Amazon Redshift:** I highly recommend Amazon Redshift for improving work efficiency as it is a fully managed service by Amazon. You just have to concentrate on your business requirements and get things done. Amazon Redshift was built on top of PostgreSQL, so it supports all the features of it. **What problems is Amazon Redshift solving and how is that benefiting you?** I work for one of the world's top 10 pharmaceutical clients. We ingest and process huge amounts of sales and marketing data. We use amazon redshift as our data warehouse, ETL processing, MSTR reporting etc. ### 21. System Analyst **Rating:** 4.0/5.0 stars **Reviewed by:** Teuku Muhammad F. | Data Engineering, Small-Business (50 or fewer emp.) **Reviewed Date:** July 11, 2022 **What do you like best about Amazon Redshift?** Databases relational view, navbar view, the quality nad the services **What do you dislike about Amazon Redshift?** Price for premium services, not open source for spesific data **What problems is Amazon Redshift solving and how is that benefiting you?** Interesting services for developing databases, maintenance, and flexible cloud services ### 22. It will be the next work place **Rating:** 4.0/5.0 stars **Reviewed by:** Md. Khairul H. | D, Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Amazon Redshift?** We can easily scale up during any pick ETL time. **What do you dislike about Amazon Redshift?** no.It is working like other DB. We can easily access it **What problems is Amazon Redshift solving and how is that benefiting you?** All the info are available in google. ### 23. Redshift database as reporting layer **Rating:** 5.0/5.0 stars **Reviewed by:** Vishal B. | BI Sales Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 13, 2022 **What do you like best about Amazon Redshift?** Amazon redshift is easy to use and cheap cloud solution with s3 integration. I used it for reporting later and querying it using alaiyon was very easy and helpful. **What do you dislike about Amazon Redshift?** I do not have any negative feedback. My experience is good with Amazon tools. **What problems is Amazon Redshift solving and how is that benefiting you?** We were moving our legacy system to cloud and with Amazon redshift we could spin multiple warehouse on single instance and ease of query. We were using reporting layer ### 24. Gold standard in terms of data warehousing! **Rating:** 4.5/5.0 stars **Reviewed by:** Nitin P. | Finance Team Lead, Enterprise (> 1000 emp.) **Reviewed Date:** July 01, 2022 **What do you like best about Amazon Redshift?** The following things are great about amazon redshift - - Scalability - Cost management - Backup **What do you dislike about Amazon Redshift?** I think I am pretty satisfied with this product **What problems is Amazon Redshift solving and how is that benefiting you?** Mostly data warehousing while keeping things budget-friendly. ### 25. Great Learning exp **Rating:** 4.5/5.0 stars **Reviewed by:** Ravi B. | Business Intelligence Developer - Tableau Power BI, Enterprise (> 1000 emp.) **Reviewed Date:** July 15, 2022 **What do you like best about Amazon Redshift?** User friendly. Optimised solutions provided. Redundancy. **What do you dislike about Amazon Redshift?** Less campaigns of awareness of this tool. **What problems is Amazon Redshift solving and how is that benefiting you?** Very good ETL and database structure & easy to use ### 26. Amazon redshift feedback **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** March 29, 2022 **What do you like best about Amazon Redshift?** *Redshift uses the columnar data storage along with various data compression techniques and combined with result caching enhances the performance by multi folds. *Redshift also has massive parallel processing which distribute SQL operations and parallelize them. *Redshift spectrum is a great solution for working with massive datasets and data lakes via redshidt **What do you dislike about Amazon Redshift?** *Redshift does not support Stored procedures. *Higher price compare to other solutions in the same sector. * It would help if user interface can be more developer friendly. **What problems is Amazon Redshift solving and how is that benefiting you?** We were spending considerable amount of resources on maintenance with our previous vendor but it was tedious and performance was also not satisfactory. Now we have a very performant and scalable solution with redshift. ### 27. The lifeline for Data Engineers **Rating:** 4.0/5.0 stars **Reviewed by:** Yugesh R. | Associate Data QA Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** December 13, 2021 **What do you like best about Amazon Redshift?** The salient feature of Amazon redshift is that it enables us to access shared databases within the organization. Easy to use DDL and DML queries. The in-built functions are easy to use and help significantly in the faster execution of queries. **What do you dislike about Amazon Redshift?** As of now, I have nothing to complain about Amazon Redshift. One of the best products that Amazon has to offer. **What problems is Amazon Redshift solving and how is that benefiting you?** I have been using Redshift for data analysis and database storage. It helps us to store data in various RDS and helps to share data within the organization. ### 28. Redshift is costly compared to alternatives such as data lake and RDS **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** March 31, 2022 **What do you like best about Amazon Redshift?** it is RDBMS database and is proven to handle huge amounts of data at scale. On the other hand, it's very handy for me to handle reporting tasks at a time when I had very little cloud experience. **What do you dislike about Amazon Redshift?** It is not serverless and it costs huge amounts of money to maintain the database. It's not a great tool for start-up to performing data analytics tasks **What problems is Amazon Redshift solving and how is that benefiting you?** We are using redshift to perform critical data reporting tasks, as well as handling ad-hoc queries. The best thing is that Redshift is well integrated with many 3rd party solutions, such as powerbi so that we can save a lot of development time to make something happen ### 29. Amazon Redshift Review **Rating:** 5.0/5.0 stars **Reviewed by:** Kallesha C. | Data Enigneer - Consultant II , Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2022 **What do you like best about Amazon Redshift?** √ Most Powerful analytical Darawarehoude DB cluster √it comes with many options like memeory optimised, storage optimised ✓You can scale up/down cluster based on increasing data ✓ it's integrated with S3, you can S3 spectrum for analysing data directly on S3, you can join the tables on Redshift ✓Redshift introduced serverless, you don't need to worry about provising of cluster ✓Most efficient for PB data **What do you dislike about Amazon Redshift?** ✓ sometimes internal Redshift issue makes cluster down ✓ when you delete records, records are just marked for delete, you need run vaccum for delete records completely **What problems is Amazon Redshift solving and how is that benefiting you?** Using Redshift & Spectrum maintaing pb Data effectively, Reduced ETL load from 14 hours to 6 hours ### 30. Amazon Redshift **Rating:** 4.5/5.0 stars **Reviewed by:** Harish S. | Development Team Lead, Enterprise (> 1000 emp.) **Reviewed Date:** March 14, 2022 **What do you like best about Amazon Redshift?** It's widely adopted, ease of administration, ideal for data lakes, querying is very easy, storage is columnar, security is excellent. **What do you dislike about Amazon Redshift?** In terms of disadvantages it's not a multi cloud solution, pricing is more,it's not a Serverless architecture, performance, concurrent execution, master node plays important role. **Recommendations to others considering Amazon Redshift:** Please go ahead with the Amazon redshift. **What problems is Amazon Redshift solving and how is that benefiting you?** Data processing and data collection is the main problem of any business This is taken care by Redshift. In terms of benefits redshift is very useful for big data. ### 31. Best Cloud Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Venkatesh M. | Systems Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 02, 2022 **What do you like best about Amazon Redshift?** Integration with ML tools is one of the most useful features to do forecast and predicting of large data and pricing is also good **What do you dislike about Amazon Redshift?** Nothing everything is very good and performance is also better **Recommendations to others considering Amazon Redshift:** It contains lots of features better to explore every feature one by one and try them according to your needs **What problems is Amazon Redshift solving and how is that benefiting you?** Working on a forecast related data warehouse project using ML Tools and also for analyzing the data ### 32. Redshift : Good Cloud DW **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Amazon Redshift?** As it is cloud based DW, no need to maintain the data centre physically at our place. **What do you dislike about Amazon Redshift?** Some time query response is slow as it provides pagination output. **What problems is Amazon Redshift solving and how is that benefiting you?** We uad used it as cloud DW to store the large amount of data without any restriction of data size. It xan be scale up very easily. ### 33. Amazon Redshift Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Amazon Redshift?** * fast performance, *excellent reliability *outstanding scalability can scale up from few GB to TB *easy to set up and work *high security option *Good analytical tool easy to integrate with s3 **What do you dislike about Amazon Redshift?** *Server down due to some internal issues which will be difficult to identify *Pricing is more compare to similar warehouse tool *No good useriterface. *Faced memory and timeout problems **Recommendations to others considering Amazon Redshift:** A scalable application that gives an extremely good performance. easy to set up, use and maintain. **What problems is Amazon Redshift solving and how is that benefiting you?** We have data coming from different ERPs which we are storing in a centralized warehouse. Data size is in few TB and also we have built data mart and business-critical reports on top of i. ### 34. Amazon redshirt review **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 23, 2022 **What do you like best about Amazon Redshift?** * Very scalable application * Very easy to set up and learn * Performance is at peak * Good security features * Easy to integrate with s3 * Very good tool for data lake and data mart and large datawarehouse also **What do you dislike about Amazon Redshift?** * some time cluster down due to some internal redshirt issue and have enoouter time out issues *Can make it more sql friendly user interface * Price is more compared similar products **What problems is Amazon Redshift solving and how is that benefiting you?** We have centralized data warehouse and data lake in redshift very data is in few TB. We had lot of performance issue with previous vendor ( i.e oracle). now we are seeing Massive performance bost and easy to maintain. ### 35. Powerful DataWarehouse tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** November 09, 2021 **What do you like best about Amazon Redshift?** It's such an efficient tool for data manipulation, implement Data Marts and Data Warehouse in Amazon Readshift is as simple as it gets; the query language and internal functions have all the tools that you need to accomplish your task **What do you dislike about Amazon Redshift?** 3 words: "Serializable Isolation Violation" a DataWarehouse is expected to have a lot of hits on the information, and this error is really common 2 operations clash no big deal but having an internal coordinator that deals and avoid this would be awesome for redshift **Recommendations to others considering Amazon Redshift:** If you have experience with SQL you are set up, just understand the principals of Datawarehousing to create and effective project **What problems is Amazon Redshift solving and how is that benefiting you?** We are creating Data Marts for each department with Star Schemas, this is becoming a fast and efficient source of truth for a lot of the daily process and continues to grows ### 36. I got some opportunity to work on redshift to create some views and pipeline. It was new to me. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Entertainment | Small-Business (50 or fewer emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Amazon Redshift?** Process is much easier to access redshift, good for large dataset, performance is good even complex logic implementation. **What do you dislike about Amazon Redshift?** Sometimes services works slow or little server downtime I don't like. Expecting more user friendly UI. **What problems is Amazon Redshift solving and how is that benefiting you?** I am using it for big data computation to solve complex logic and create data model ### 37. Efficient and fast but costly **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** July 29, 2022 **What do you like best about Amazon Redshift?** Massive Parallel Processing, No ops, choice of compression algorithms available, optimization features of distribution, sorting and vaccuming **What do you dislike about Amazon Redshift?** Vaccume operations on a sorted table are too costly **What problems is Amazon Redshift solving and how is that benefiting you?** reports on huge wide column logs. Helping with low latency adhock queries and storage optimizations ### 38. Really smooth experience all around and makes work much easier **Rating:** 4.5/5.0 stars **Reviewed by:** Vineet S. | Data Scientist 3, Small-Business (50 or fewer emp.) **Reviewed Date:** April 06, 2022 **What do you like best about Amazon Redshift?** Found it very easy to organize data and the speed of recall was so good **What do you dislike about Amazon Redshift?** Linking with other platforms at times seemed like a tedious task **Recommendations to others considering Amazon Redshift:** Go for it with a bit of preparation **What problems is Amazon Redshift solving and how is that benefiting you?** Attribution and ad campaign related work has become much easier. The huge datasets are easy to handle ### 39. 4 years of experience **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 21, 2022 **What do you like best about Amazon Redshift?** Much useful to store intermediate and full pledged data or metadata information **What do you dislike about Amazon Redshift?** Time for connecting it to native tools like specially on-premise tools **What problems is Amazon Redshift solving and how is that benefiting you?** easy retrieval and storage of data and schemas and can accommodate user level schema creation using some external packages/processes. ### 40. Loading and working on large flat files are easy on Redshift. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2022 **What do you like best about Amazon Redshift?** Loading and working on large flat files are easy on Redshift. **What do you dislike about Amazon Redshift?** Please make the UI more interactive like on menus. **What problems is Amazon Redshift solving and how is that benefiting you?** I work on various large flat files with a huge number of columns and I feel comfortable when I work on those using Redshift. ### 41. It's a good platform to store large volume of data in cheap prices. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** July 12, 2022 **What do you like best about Amazon Redshift?** Amazon redshift is good to store the big datasets and it's pretty straightforward to use as well **What do you dislike about Amazon Redshift?** It takes some time to load data(ingestion) but we are getting used to it. **What problems is Amazon Redshift solving and how is that benefiting you?** Its helping us to store the data and using it further for actionable insights ### 42. Good Datawarehouse solution for large scala data **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 01, 2022 **What do you like best about Amazon Redshift?** Fault tolerant, Serverless feature, query with custom tools, easy integration with AWS services, cost effective any compared to other DWH cloud solutions in market. **What do you dislike about Amazon Redshift?** Doens't support parallel loading from other sources. **What problems is Amazon Redshift solving and how is that benefiting you?** Datawarehouse, Big Data Integration ### 43. Its demanding skill and we have a lot to learn and explore. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Mid-Market (51-1000 emp.) **Reviewed Date:** July 17, 2022 **What do you like best about Amazon Redshift?** The performance and lower latency.it's good for large data set **What do you dislike about Amazon Redshift?** Some time server was not accessible due to some reason may it was there down time. **What problems is Amazon Redshift solving and how is that benefiting you?** We are doing data visualisation so before we need clean data so we are doing ETl. ### 44. The best cloud data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 16, 2022 **What do you like best about Amazon Redshift?** Instant scalability for massive amount of data **What do you dislike about Amazon Redshift?** It doesn't not parallely load from different sources **What problems is Amazon Redshift solving and how is that benefiting you?** Storing and managing the company datawarehouse with minimal interference for support ### 45. Datawarehouse AWS Redshift Service **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Enterprise (> 1000 emp.) **Reviewed Date:** May 04, 2022 **What do you like best about Amazon Redshift?** Easily accessible and load and unload the data. Performance of data retrieval is very fast comparatively to the Onpermises database **What do you dislike about Amazon Redshift?** Pricing and the when choosing the distribution list and sort key an suggestion could have been given in the AWS cloud plaform **Recommendations to others considering Amazon Redshift:** Know the architecture, dist key and sort key and few queue management in Reshift **What problems is Amazon Redshift solving and how is that benefiting you?** Loading and unloading data is faster from the S3 service, Performace is good comparatively On-premises database, queue management is good. ### 46. Redshift saved the day! **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Small-Business (50 or fewer emp.) **Reviewed Date:** July 27, 2022 **What do you like best about Amazon Redshift?** Selfservice and auto managed. No major operational overheads **What do you dislike about Amazon Redshift?** waiting for something to add here as of now **What problems is Amazon Redshift solving and how is that benefiting you?** It is the warehouse solution in our poc and we showcase it to probable customers going forward ### 47. Good - Cloud DW **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Amazon Redshift?** Nice Cloud DW with handy Ui which allow us the unlimited storage **What do you dislike about Amazon Redshift?** Some times query output is slow as it gives as pagenation results **What problems is Amazon Redshift solving and how is that benefiting you?** With scale up storage and pay what you use facility, it is great Dw ### 48. recommend **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Consumer Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 20, 2022 **What do you like best about Amazon Redshift?** Speed of execution is pretty good & as expected **What do you dislike about Amazon Redshift?** the load time is more as compared to other cloud services **What problems is Amazon Redshift solving and how is that benefiting you?** Data visualisation ### 49. Redshift - Fast and Reliable **Rating:** 4.5/5.0 stars **Reviewed by:** Ankan D. | Python Developer/AWS Cloud Engineer | TCS Digital, Enterprise (> 1000 emp.) **Reviewed Date:** March 15, 2022 **What do you like best about Amazon Redshift?** Amazon Redshift is highly available, scalable and very easy to use with the API it provides. We can seamlessly upload data from S3 to Redshift using Glue jobs. **What do you dislike about Amazon Redshift?** There aren't a lot of downsides to using Redshift, except there was a single downtime when most Amazon services went down. **What problems is Amazon Redshift solving and how is that benefiting you?** Needed to shift the on-prem server data to AWS Redshift for further processing. ### 50. Amazon Redshift: Better Management of Cloud Data Warehouse **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.) **Reviewed Date:** August 01, 2022 **What do you like best about Amazon Redshift?** Ease of querying tables that are ideal for data lakes **What do you dislike about Amazon Redshift?** Amazon Redshift is only exclusive to AWS users. **What problems is Amazon Redshift solving and how is that benefiting you?** You can easily scale up/down capacity and performance according to the existing requirements. ## Amazon Redshift Discussions - [Should I use with a data mart for a frontend tool that make request on it ?](https://www.g2.com/discussions/should-i-use-with-a-data-mart-for-a-frontend-tool-that-make-request-on-it) - 3 comments, 3 upvotes - [Is Amazon redshift good for large datasets considering its cost.](https://www.g2.com/discussions/is-amazon-redshift-good-for-large-datasets-considering-its-cost) - 2 comments, 1 upvote - [Is AWS redshift a database?](https://www.g2.com/discussions/is-aws-redshift-a-database) - 1 comment - [When can I use Amazon redshift?](https://www.g2.com/discussions/when-can-i-use-amazon-redshift) - 3 comments - [What are the characteristics of redshift?](https://www.g2.com/discussions/what-are-the-characteristics-of-redshift) - 2 comments - [View Amazon Redshift pricing details and edition comparison](https://www.g2.com/products/amazon-redshift/reviews?page=4§ion=pricing&secure%5Bexpires_at%5D=2026-07-14+18%3A56%3A32+-0500&secure%5Bsession_id%5D=625f9443-9944-4e0d-b6e8-9188492c2f56&secure%5Btoken%5D=8d190f0676a602659fbc9f9ade21ea35ba6cc6a443915b99ca9d6e10e72f220f&format=llm_user) ## Amazon Redshift Integrations - [Informatica Cloud Data Integration](https://www.g2.com/products/informatica-cloud-data-integration/reviews) - [Informatica Data Engineering](https://www.g2.com/products/informatica-data-engineering/reviews) - [Liquibase](https://www.g2.com/products/liquibase/reviews) - [Metabase](https://www.g2.com/products/metabase/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) ## Amazon Redshift Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Storage** - Data Model - Data Types **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Availability** - Auto Sharding - Auto Recovery - Data Replication **Deployment** - On-Premise - Cloud **Performance** - Integrated Cache **Performance ** - Scalability **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Security** - Data Governance - Data Security **Support** - Multi-Model - Operating Systems **Generative AI** - AI Text Generation - AI Text Summarization ## Top Amazon Redshift Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,144 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (707 reviews) - [Rocket Vertica](https://www.g2.com/products/rocket-vertica/reviews) - 4.3/5.0 (195 reviews)