--- title: Amazon Redshift Reviews meta_title: 'Amazon Redshift Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 404 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: 404 scale: '5' date_modified: '2026-08-07' 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:** 404 ## 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 value the **fast querying capabilities** of Amazon Redshift, enabling efficient analysis of large datasets seamlessly. (5 reviews) - Users praise the **easy integrations** with other software, enhancing data solutions within the Amazon Redshift ecosystem. (5 reviews) - Users find Amazon Redshift's **ease of use** exceptional, facilitating quick access and efficient data management. (4 reviews) - Users value the **easy integrations** of Amazon Redshift, enhancing their ability to build seamless data solutions. (4 reviews) - Users praise the **impressive speed and scalability** of Amazon Redshift, optimizing data management and query performance. (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 Redshift, especially regarding advanced analytics and multi-language support for coding. (4 reviews) - Users note significant **software limitations** with Redshift, particularly regarding cost and performance issues with complex queries. (4 reviews) - Users find the **complexity of optimizations** in Amazon Redshift burdensome, requiring significant management and maintenance effort. (3 reviews) - Users face **query issues** with Amazon Redshift, requiring extensive optimization and management to maintain performance. (3 reviews) - Users find the **query optimization process cumbersome** , as it requires significant effort and specialized knowledge for efficiency. (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: 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. ### 2. It can have more functionalities **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 26, 2022 **What do you like best about Amazon Redshift?** Sql makes it easy to use and more people can use it **What do you dislike about Amazon Redshift?** It would be great if we could structure unstructured data there and then **What problems is Amazon Redshift solving and how is that benefiting you?** No major problems to be honest ### 3. Amazon Redshift review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Mid-Market (51-1000 emp.) **Reviewed Date:** July 06, 2022 **What do you like best about Amazon Redshift?** The way it stores the data and the preformance of retrieving the data is very good. **What do you dislike about Amazon Redshift?** That we need to depend on the cloud capacity **What problems is Amazon Redshift solving and how is that benefiting you?** It is solving the biggest issue of query execution time with redshift it is very fast ### 4. WONDERFUL EXPERIENCE **Rating:** 5.0/5.0 stars **Reviewed by:** Manjeet S. | Associate Operation Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** March 23, 2022 **What do you like best about Amazon Redshift?** I like because it is Faster than psql and also data refreshing is also fast. **What do you dislike about Amazon Redshift?** User interface could me improvise and it'll become the best in industry. **Recommendations to others considering Amazon Redshift:** It is easy to use and faster, so please try and make useful for you. **What problems is Amazon Redshift solving and how is that benefiting you?** We're using Amazon redshift..upload data faster. Also it's helpful for improving customer experience. ### 5. Best cloud based data warehousing solution! **Rating:** 4.0/5.0 stars **Reviewed by:** Shweta K. | Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** March 14, 2022 **What do you like best about Amazon Redshift?** I really loved the low maintenance, security and scale-up or scale-down flexibility. This was a game changer for our company the last time I was there. **What do you dislike about Amazon Redshift?** I don't have any complaints as of now. I had used it in my past organization. **What problems is Amazon Redshift solving and how is that benefiting you?** We were mainly focused on data storage and accessibility issue. Cost was another challenge that was tackled. ### 6. Great db for your datalake usage **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Amazon Redshift?** 1. Great computing power 2. Flexibility in scaling capacity 3. High performance data analysis **What do you dislike about Amazon Redshift?** UI interface is good, but It can be better **What problems is Amazon Redshift solving and how is that benefiting you?** Storing and managing the data at a fast pace ### 7. Indirect user; use it as enterprise data warehouse **Rating:** 2.5/5.0 stars **Reviewed by:** Jared R. | Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** February 15, 2022 **What do you like best about Amazon Redshift?** It seems to be a great solution for our data science and engineering teams to store, access, and later merge data sets together for reporting and analysis purposes **What do you dislike about Amazon Redshift?** N/A - I do not use this product directly enough to give specific feedback **What problems is Amazon Redshift solving and how is that benefiting you?** I primarily use Redshift to push survey data to later join it with other engagement datapoints we have about customers. The ability to link datasets improves our performance. ### 8. It provides good solution for data warehousing, It also very convenient to use. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 05, 2022 **What do you like best about Amazon Redshift?** It provides a cost-effective solution. The integration with different tools/applications such as PowerBI, DBeaver & DBT is very easy. **What do you dislike about Amazon Redshift?** The initial setup of Redshift can be difficult for beginners. **What problems is Amazon Redshift solving and how is that benefiting you?** It gives a good cloud solution for data warehousing ### 9. Amazon redshift is great data warehouse . **Rating:** 4.5/5.0 stars **Reviewed by:** Nishant g. | Junior Manager Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** April 01, 2022 **What do you like best about Amazon Redshift?** Smooth UI to run the connection.The data warehouse can be connected to multiple source. **What do you dislike about Amazon Redshift?** Query optimization suggestion should be given more accurate **Recommendations to others considering Amazon Redshift:** Great tool to have for crating pipeline destination and faster access to data available **What problems is Amazon Redshift solving and how is that benefiting you?** Connecting multiple data source so create a temp aggreagate table ### 10. Scalable,fast and vast variety of functions **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Broadcast Media | Mid-Market (51-1000 emp.) **Reviewed Date:** April 11, 2022 **What do you like best about Amazon Redshift?** 1. Different functions to extract unstructured data like JSON structures. 2. Can be integrated with AWS S3 using external tables **What do you dislike about Amazon Redshift?** pricing, concurrent processing is not easy and is not serverless. **What problems is Amazon Redshift solving and how is that benefiting you?** Exploded deeply nested array JSON structure using the extract array functions. ### 11. Nice Cloud DW **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Wireless | Enterprise (> 1000 emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Amazon Redshift?** With great UI, it gives us more power to deal with large amount of data. **What do you dislike about Amazon Redshift?** Sometimes Query result is slow due to pagenated output **What problems is Amazon Redshift solving and how is that benefiting you?** Quick service, Scale up facility ### 12. Amazon Redshift is quick and easy to use and integrate as a dwh **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Packaging and Containers | Mid-Market (51-1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Amazon Redshift?** External tables concept and easy integration with visualization and ease of development. **What do you dislike about Amazon Redshift?** Cannot declare variable just like we do in other db. **What problems is Amazon Redshift solving and how is that benefiting you?** Massive parallel procesing and cloud data warehouse ### 13. Amazon Redshift is a very good Database. Easy to use, good performance **Rating:** 4.0/5.0 stars **Reviewed by:** Santosh Damodaran U. | Lead Data Engineer I, Mid-Market (51-1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Amazon Redshift?** The columnar nature of the DB and the excellent performance. **What do you dislike about Amazon Redshift?** The lack of keys and the care required as there are no indices. **Recommendations to others considering Amazon Redshift:** Excellent performance for very large-scale data sets. Columnar database, unlimited storage at a very affordable price. **What problems is Amazon Redshift solving and how is that benefiting you?** Big Data storage and retrieval. Data warehousing and business intelligence. ### 14. It provides best data warehouse in cloud in terms of usage to developer and also in performance **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Enterprise (> 1000 emp.) **Reviewed Date:** July 27, 2022 **What do you like best about Amazon Redshift?** Super data type. Partner console integra **What do you dislike about Amazon Redshift?** Ra3 nodes with managed storage is helpful for storage compute **What problems is Amazon Redshift solving and how is that benefiting you?** Big Data warehousing for energy transition projects ### 15. It's way better than traditional data warehousing solutions!!! **Rating:** 4.5/5.0 stars **Reviewed by:** Shringarika Jais A. | Graduate Assitant, Small-Business (50 or fewer emp.) **Reviewed Date:** March 14, 2022 **What do you like best about Amazon Redshift?** The 2 things I enjoy the most - Easy to use and integrate - No huss or fuss to do maintenance or downtime. **What do you dislike about Amazon Redshift?** I enjoy working with it. No dislikes at all. **What problems is Amazon Redshift solving and how is that benefiting you?** As a GA, I am helping in migrating student data as well as keeping record of our donors and alumni. ### 16. Great service by AWS to handle data lake and warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Networking | Enterprise (> 1000 emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Amazon Redshift?** Great performance, dynamic scalability , connection with other services mostly with glue **What do you dislike about Amazon Redshift?** UI interface is good but can be improved more **What problems is Amazon Redshift solving and how is that benefiting you?** integration with data pipelines ### 17. Amazing experience with redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Madhu S. | Assistant Manager Compliance, Enterprise (> 1000 emp.) **Reviewed Date:** March 23, 2022 **What do you like best about Amazon Redshift?** The Amazon redshift is very faster as compare with other database, like SQL etc **What do you dislike about Amazon Redshift?** There is nothing that i don't like but we should make it more user friendly. **What problems is Amazon Redshift solving and how is that benefiting you?** Upload large data in sort time and provide quick results to customers. Improve better customer experience ### 18. Best service to usw **Rating:** 5.0/5.0 stars **Reviewed by:** Sagar P. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 10, 2022 **What do you like best about Amazon Redshift?** It is very fast and cheaper to use product compared with other cloud products. Also this is very friendly interms of pricing for the start ups companies. **What do you dislike about Amazon Redshift?** Sometimes we get connection timeout errors. **What problems is Amazon Redshift solving and how is that benefiting you?** We slove all the analysis of our history data and helps us realistic with the steam data. ### 19. End user Amazon service **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Banking | Small-Business (50 or fewer emp.) **Reviewed Date:** July 12, 2022 **What do you like best about Amazon Redshift?** Faster performance, massively parallel, easy to setup, deploy and manage **What do you dislike about Amazon Redshift?** I cant 100% managed, not a multi cloud solution **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift help me in problem bigdata ### 20. Redshift MPP **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 16, 2022 **What do you like best about Amazon Redshift?** Faster query execution time and scalability **What do you dislike about Amazon Redshift?** Cost of redshift. Owning data warehouse is high **What problems is Amazon Redshift solving and how is that benefiting you?** Data as service and building fast analytics engine ### 21. Perfect for Data warehouse Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Roshan N. | Lead Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 12, 2022 **What do you like best about Amazon Redshift?** Replication is easy and user has better control in settings **What do you dislike about Amazon Redshift?** Expensive if the data size is low. You will end up paying more for small data set. **What problems is Amazon Redshift solving and how is that benefiting you?** CRM for pharmaceutical company ### 22. Redshift is amazing, its easy to use and allow parallel processing **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 07, 2022 **What do you like best about Amazon Redshift?** we can handle large scale data sets easily and also do parallel processing, its easy to transfer data and handle large scale of data. I think its the best tool which i use **What do you dislike about Amazon Redshift?** I am a new user of redshift, so currently I am not having dislike to it **What problems is Amazon Redshift solving and how is that benefiting you?** currently, we shift data from on-premise to cloud so I learn everything now and its beneficial for me ### 23. really customer Centric tool and easy to access and connect **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** July 06, 2022 **What do you like best about Amazon Redshift?** Connectivity, accessible, user interface **What do you dislike about Amazon Redshift?** Sometimes issue faced with data load from S3 **Recommendations to others considering Amazon Redshift:** Yes **What problems is Amazon Redshift solving and how is that benefiting you?** DB maintenance , load blancing , eazy to connectivity ### 24. Good Product for faster data retrieval **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** April 07, 2022 **What do you like best about Amazon Redshift?** The way it manages the data in backend, is main reason the fast data processing. **What do you dislike about Amazon Redshift?** Nothing as such because I am moreover an end consumer of the product to perform the analytical operation **What problems is Amazon Redshift solving and how is that benefiting you?** The large volume retail data is stored in redshift which helps us to do the analytics on top of it, this is helping us to generate great insights and do the future predictions ### 25. Wonderful experience in Amazon redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Akshay N. | Network migration specialist, Enterprise (> 1000 emp.) **Reviewed Date:** March 23, 2022 **What do you like best about Amazon Redshift?** Great learning experience and easy to learn **What do you dislike about Amazon Redshift?** No downsides, everything is flawless and perfect **Recommendations to others considering Amazon Redshift:** Easy to use, I would recommend everyone to try this **What problems is Amazon Redshift solving and how is that benefiting you?** Helping my organization to use Amazon redshift as a permanent solution ### 26. Redshift is fasted and consistent database **Rating:** 4.5/5.0 stars **Reviewed by:** Roman M. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 16, 2022 **What do you like best about Amazon Redshift?** Performance of redshift and it handle big data easily **What do you dislike about Amazon Redshift?** There is no SQL like thing if it is there then it is helpful for SQL developer **Recommendations to others considering Amazon Redshift:** Use this process big data and analytics domain **What problems is Amazon Redshift solving and how is that benefiting you?** Real world problem ### 27. Amazing experience so far. **Rating:** 5.0/5.0 stars **Reviewed by:** Rakesh K. | Data and Analytics Lead, Enterprise (> 1000 emp.) **Reviewed Date:** March 22, 2022 **What do you like best about Amazon Redshift?** I am using redshift database to connecting Qlik Sense, it's more faster. **What do you dislike about Amazon Redshift?** I don't think any dislike, it's very good tool to use. **What problems is Amazon Redshift solving and how is that benefiting you?** Load faster data as compared with other like, SQL ### 28. Redshift is very much fast and easy to use for analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Anil K. | SQL Server and Redshift DBA, Mid-Market (51-1000 emp.) **Reviewed Date:** April 05, 2022 **What do you like best about Amazon Redshift?** Redshift doesn't need much DB maintenance **What do you dislike about Amazon Redshift?** Schema level or DB level backups not feasible in redshift. **What problems is Amazon Redshift solving and how is that benefiting you?** Perticuler table restore and performance tuning is very good. ### 29. Faster Data ware house in the cloud **Rating:** 5.0/5.0 stars **Reviewed by:** Deepu R. | Senior Manager, Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2022 **What do you like best about Amazon Redshift?** Speed Convenience SQL compatibility Price **What do you dislike about Amazon Redshift?** Lack of some of the function which Snowflake offers **What problems is Amazon Redshift solving and how is that benefiting you?** Analytics Usecases which involves huge amount of data ### 30. SQL Warehouse- From Amazon **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Small-Business (50 or fewer emp.) **Reviewed Date:** March 30, 2022 **What do you like best about Amazon Redshift?** Ease of use- SQL wrapper Massively parallel processing- Lots of speed Secure Scalable via the native AWS config Low cost solution to replace legacy warehouses **What do you dislike about Amazon Redshift?** Does not supprt UI based querying yet Can get pricier to maintain over time **What problems is Amazon Redshift solving and how is that benefiting you?** Building a data lake to make the contact center operations more efficient. Ingesting data from multiple data sources into redshift and modeling the data for consumption ### 31. Best db for parallel processing **Rating:** 4.0/5.0 stars **Reviewed by:** Ganesh S. | Specialist - Data Engineering, Small-Business (50 or fewer emp.) **Reviewed Date:** April 04, 2022 **What do you like best about Amazon Redshift?** Best db for parallel processing and bigdata processing **What do you dislike about Amazon Redshift?** Not user friendly, the training needs to be updated **Recommendations to others considering Amazon Redshift:** It's ok ok **What problems is Amazon Redshift solving and how is that benefiting you?** All High volume Data ### 32. Cool to work with **Rating:** 5.0/5.0 stars **Reviewed by:** Arjun P. | Human Resources Manager, Enterprise (> 1000 emp.) **Reviewed Date:** April 06, 2022 **What do you like best about Amazon Redshift?** Widely adopted Administration is easy Large scale services **What do you dislike about Amazon Redshift?** Not as such But should have pricing consideration for small scale business **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehouse implementation ### 33. Much Faster then others **Rating:** 5.0/5.0 stars **Reviewed by:** Pradeep J. | Lead Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** March 23, 2022 **What do you like best about Amazon Redshift?** It's simply the best. Totally satisfied with the performance. **What do you dislike about Amazon Redshift?** Everything is good in it. Seriously, nothing bad. **What problems is Amazon Redshift solving and how is that benefiting you?** Helped in improving query performance by using compression encodings. Much faster resolution. ### 34. Very nice dwh database **Rating:** 4.0/5.0 stars **Reviewed by:** Ankit B. | Senior Data Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** April 08, 2022 **What do you like best about Amazon Redshift?** Bulk load Vast SQL functions Optimized query plan **What do you dislike about Amazon Redshift?** No real time support Parallel data loading **What problems is Amazon Redshift solving and how is that benefiting you?** Reports and analytics ### 35. Redshift for Data Warehousing **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** April 19, 2022 **What do you like best about Amazon Redshift?** High-Speed columnar database which flexibility around data storage and retrieval strategies. **What do you dislike about Amazon Redshift?** Housekeeping activities required like vacuum and analyze for best performance. **What problems is Amazon Redshift solving and how is that benefiting you?** Cloud solution for commerce analytics is achieved by us using Redshift. The AWS Support portal for the queries encountered is the biggest benefit I think. ### 36. Good overall **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Amazon Redshift?** Easy to use and also clear understanding **What do you dislike about Amazon Redshift?** The 1 hour refresh every hour is not good **What problems is Amazon Redshift solving and how is that benefiting you?** Data pulls, ad hocs ### 37. really impressive! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Food & Beverages | Enterprise (> 1000 emp.) **Reviewed Date:** March 14, 2022 **What do you like best about Amazon Redshift?** I am very impressed by this solution. Seamless integration and scalability blew my mind. **What do you dislike about Amazon Redshift?** There is nothing to dislike about it. I mean it could be a little cheaper but I wouldn't say it's a dislike but more of a suggestion to increase market penetration. **What problems is Amazon Redshift solving and how is that benefiting you?** We are trying to create an ecosystem of smart tools to increase productivity and tackle competition. ### 38. Good shift for traditional DWH **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** April 08, 2022 **What do you like best about Amazon Redshift?** Wide renage of services Data processing is faster Easy for administrative and querying big data **What do you dislike about Amazon Redshift?** Not as such but parallel execution performance was not bad that much but can be look after **Recommendations to others considering Amazon Redshift:** It is easy to implement DWH end to end solution **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehousing and data processing ### 39. Easy and Robust Datawarehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Saurabh G. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 17, 2022 **What do you like best about Amazon Redshift?** Performance Support Features Compatible **What do you dislike about Amazon Redshift?** Sometimes faced memory and time out issues **What problems is Amazon Redshift solving and how is that benefiting you?** Migration from data lake to data warehouse ### 40. Flexible and secure Cloud DB. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 22, 2022 **What do you like best about Amazon Redshift?** The security , ease of writing queriesan **What do you dislike about Amazon Redshift?** Security, performance and connectivity from tools and other cloud platforms. **What problems is Amazon Redshift solving and how is that benefiting you?** Creating datawarehouse nad data marts. ### 41. Warehouse at scale **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** March 29, 2022 **What do you like best about Amazon Redshift?** Ease of use, ease of scale, super helpful abstractions, easy to manage **What do you dislike about Amazon Redshift?** Not serverless, is not cloud agnostic, auto tuning in development **What problems is Amazon Redshift solving and how is that benefiting you?** Working towards building data lakes both customer as well as business specific. Enable at scale processing of humongous data with a convenient SQL layer based querying. ### 42. Amazon Redshift the Red hot product **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Business Supplies and Equipment | Enterprise (> 1000 emp.) **Reviewed Date:** March 21, 2022 **What do you like best about Amazon Redshift?** The massive parallel processing capability is top-notch and one of the USPs of Amazon Redshift. **What do you dislike about Amazon Redshift?** It does not work as a live app database which sometimes can make consider other option available in the market. **What problems is Amazon Redshift solving and how is that benefiting you?** Moving from typical RDMS on-premise data warehouse to cloud-based solution has always been of great help. ### 43. As a data analyst excellent experience. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 26, 2022 **What do you like best about Amazon Redshift?** Easy to use and querying, Ideal for data lakes. The ability to scale is one of the most important aspects. **What do you dislike about Amazon Redshift?** Not 100% managed. Only receive support for parallel upload with specific data. Stored procedures are not available. **What problems is Amazon Redshift solving and how is that benefiting you?** Quick solution and high-performance warehouse solution. Integrates with third-party tools. ### 44. Worked on Amazon redshift for more than 2 years,very good data warehousing tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Amazon Redshift?** AWS services are easy to use and are on cloud **What do you dislike about Amazon Redshift?** No feature of shared DB in amazon Redshift,this can be improved **Recommendations to others considering Amazon Redshift:** Start using AWS services and Redshift for an amazing ETL experience **What problems is Amazon Redshift solving and how is that benefiting you?** We are working on developing ETL based solutions using AWS redshift for Pharma Based clients ### 45. Amazon Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** April 12, 2022 **What do you like best about Amazon Redshift?** Compared to its competitors, Amazon Redshift is the best! **What do you dislike about Amazon Redshift?** There's nothing to dislike about it..... **Recommendations to others considering Amazon Redshift:** Maximize its services as all its services are beneficial and helpful! **What problems is Amazon Redshift solving and how is that benefiting you?** Handles huge volume of data which is important! ### 46. Amazing data warehousing solution! **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Mid-Market (51-1000 emp.) **Reviewed Date:** March 11, 2022 **What do you like best about Amazon Redshift?** - Cloud-based - Scalable - Cost effective - Super fast **What do you dislike about Amazon Redshift?** As of now, my exposure has been limited but I haven't found anything that I disliked yet. **What problems is Amazon Redshift solving and how is that benefiting you?** Basically, I have been using Amazon Redshift to move our in-house data warehouse to the cloud. Benefits are basically easy scalability and cost-effectiveness. ### 47. Amazon Redshift is really easy to Query **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Political Organization | Small-Business (50 or fewer emp.) **Reviewed Date:** November 05, 2021 **What do you like best about Amazon Redshift?** The best part of Amazon redshift is having shared databases amongst my coworkers. It is really easy to add, drop, or edit any tables. I query redshift through data-grip and together they work really well! **What do you dislike about Amazon Redshift?** I have had some issues with setting up APIs and I have found that it can be more complicated than with other platforms such as Oracle, but overall it has not been too hard. **What problems is Amazon Redshift solving and how is that benefiting you?** I use Redshift for data analysis and database storage. It easily allows us to share data amongst other organizations as well which has been super helpful! Being able to look at the same data set with a partner has been a great benefit ### 48. Redshift Data warehouse **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Small-Business (50 or fewer emp.) **Reviewed Date:** March 28, 2022 **What do you like best about Amazon Redshift?** Easy to use interface and access. It's very good **What do you dislike about Amazon Redshift?** Nothing I could find. The scale of project which I worked was not in depth use of redshift **What problems is Amazon Redshift solving and how is that benefiting you?** I solved the problem of storing large scale data on redshift rather than Cassandra ### 49. Data analyst **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) **Reviewed Date:** March 29, 2022 **What do you like best about Amazon Redshift?** It can outperform other models. It is fast and easy to understand. Very good in performance. Easy to understand. **What do you dislike about Amazon Redshift?** Nothing in particular it is a good field to work. **What problems is Amazon Redshift solving and how is that benefiting you?** complex algorithms like finding insights from data from 1950 to 2019. ### 50. Amazon Redshift **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** March 30, 2022 **What do you like best about Amazon Redshift?** Easy, can set up quickly, cost effective, scale quickly to meet needs **What do you dislike about Amazon Redshift?** Not good for real time data loading. Not a serverless architecture **Recommendations to others considering Amazon Redshift:** Good **What problems is Amazon Redshift solving and how is that benefiting you?** Mostly I have used amazon Redshift for data querying purpose and building pipelines. ## 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=5&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-08-07+10%3A33%3A33+-0500&secure%5Bsession_id%5D=006b20e3-9148-48b5-b20c-31e0e5239f7e&secure%5Btoken%5D=9ae9aab03b23fdeaac02663a0f23b403a0c52c0d8c8dc6e07a19caa207a6ce43&format=llm_user) ## Amazon Redshift Integrations - [Fivetran](https://www.g2.com/products/fivetran/reviews) - [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 - Generative AI **Additional Functionality** - Parallel Processing - Ad hoc Analysis - Multiple Data Sources - API - In-Database Processing - Monitoring - Real-Time Reporting - Data Synchronization - Real-Time Monitoring - Data Connectors - Performance Metrics - Ad hoc Reporting - Alerts/Notifications - Access Controls/Permissions - Drag & Drop - Data Visualization - Data Import/Export - Match & Merge - Data Transformation - Secure Data Storage - Data Extraction - AI Copilot - Customizable Reports - Activity Dashboard - Data Migration - In-Memory Processing - Data Mapping ## 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 (713 reviews) - [Rocket Vertica](https://www.g2.com/products/rocket-vertica/reviews) - 4.3/5.0 (195 reviews)