--- title: Amazon Redshift Reviews meta_title: 'Amazon Redshift Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 402 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: 402 scale: '5' date_modified: '2026-06-30' 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:** 402 ## 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 find Amazon Redshift's **ease of use** invaluable for data warehousing and seamless integrations with AWS services. (7 reviews) - Users value the **seamless integrations** of Amazon Redshift, enhancing data solutions within the AWS ecosystem efficiently. (7 reviews) - Users appreciate the **easy integrations** of Amazon Redshift with the AWS ecosystem, simplifying data management and analytics. (5 reviews) - Users commend the **fast querying capabilities** of Amazon Redshift, enhancing data analysis and efficiency significantly. (5 reviews) - Users appreciate the **scalability** of Amazon Redshift, enabling efficient handling of massive data volumes seamlessly. (5 reviews) - Customer Support (4 reviews) - Features (4 reviews) - Users value the **efficiency in managing large datasets** with Amazon Redshift, making complex queries seamless and fast. (4 reviews) - Users highlight the **impressive speed and scalability** of Amazon Redshift, efficiently handling massive data volumes and complex queries. (4 reviews) - Users value the **speed and efficiency** of Amazon Redshift, enhancing their ability to manage large datasets seamlessly. (4 reviews) **What users dislike:** - Users find the **complexity of Amazon Redshift** challenging, with significant effort needed for optimization and maintenance. (5 reviews) - Users find **feature limitations** in Amazon Redshift, especially regarding advanced analytics and unstructured data support. (5 reviews) - Users face significant **software limitations** with Amazon Redshift, including performance issues and high costs at scale. (5 reviews) - Users face **query issues** due to tuning needs, concurrency challenges, and limited support for unstructured data. (4 reviews) - Users find that **query optimization requires significant effort** , leading to increased operational complexity and management challenges. (4 reviews) - Expensive (3 reviews) - Integration Issues (3 reviews) - Performance Issues (3 reviews) - Users find **slow query performance** in Amazon Redshift challenging, needing significant time for optimization and tuning. (3 reviews) - Complex Processes (2 reviews) ## Amazon Redshift Reviews ### 1. Amazon Redshift: The SOTA Data Powerhouse **Rating:** 5.0/5.0 stars **Reviewed by:** himanshu j. | Lead - Analytics, Small-Business (50 or fewer emp.) **Reviewed Date:** July 04, 2023 **What do you like best about Amazon Redshift?** Best-in-class data warehousing, integrations, support and maintenance services provided by AWS over Redshift with state-of-the-art data warehousing pipeline building and concurrency scaling features **What do you dislike about Amazon Redshift?** The batch processing disallows real-time data ingestion and analysis, impacting reporting and data consumption at other ends. Also, sometimes challenges occur when loading/unloading massive data at once or with complex queries **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift is cost-effective, high performing platform which helps us in keeping all our columnar data at one place and use other AWS services like Glue, S3 etc for better integration and data consumption ### 2. AWS Redshift Review **Rating:** 4.5/5.0 stars **Reviewed by:** Rachit M. | Entity Non Officer, Enterprise (> 1000 emp.) **Reviewed Date:** May 30, 2023 **What do you like best about Amazon Redshift?** AWS Redshift is a plug-and-play-like service provided by AWS, and it helps us to integrate load and process data within minutes. Resources are automatically provisioned and automatically scaled as per the demands **What do you dislike about Amazon Redshift?** AWS Redshift is not available in all the AWS regions. The pricing is based on usage per second, making it a little costly. It does not have any free tier. It dimension the data poorly sometimes **What problems is Amazon Redshift solving and how is that benefiting you?** AWS Redshift is a serverless offering with faster performance and massively parallel in using data warehousing activity. It provides us with faster query which ultimately helps us in the efficiency of the application ### 3. Best and easy to maintain when you have data in GBs, turn costly when data reaches in TBs **Rating:** 4.0/5.0 stars **Reviewed by:** Aniket G. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 12, 2023 **What do you like best about Amazon Redshift?** 1. A simple easy to start and easy to maintain data warehouse service by AWS. 2. Support in build optimisation and compression which result in faster query results and less memory required to store data. 3. Complete SQL support which makes data analyst easy to analyse the data. **What do you dislike about Amazon Redshift?** 1. Supports only structured data. At least it should support semi-structured data in easy ways. 2. When data increases we have to upgrade or scale out instances which becomes costlier. **What problems is Amazon Redshift solving and how is that benefiting you?** It helps in maintaining a data warehouse into which you can store data from multiple sources related to business which helps the business in perform data operations and insights and analytics. ### 4. Big data integration platform **Rating:** 4.5/5.0 stars **Reviewed by:** Rajan T. | Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Amazon Redshift?** It is a data warehouse where data reside on cloud and on top of it we can query the required data **What do you dislike about Amazon Redshift?** Not 100% managed, multi cloud solution required, not a server less architecture **What problems is Amazon Redshift solving and how is that benefiting you?** Widely adopted, scalability, strong AWS ecosystems, ease of administration ### 5. Amazon redshift review **Rating:** 3.5/5.0 stars **Reviewed by:** Sweety W. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** June 02, 2023 **What do you like best about Amazon Redshift?** Amazon redshift provides fast processing as we work on big data platforms loading of the data should be as fast as possible it is is good for querying as well as analytics **What do you dislike about Amazon Redshift?** Not that I can think about as of now but it only supports parallel upload for specific data also most important it dies not eork as live app database it does not completely supports postgres **What problems is Amazon Redshift solving and how is that benefiting you?** Its very quick solution available at readily also it gives high performance warehouse solutions for detailed analysis also machine learning is possible on Amazon redshift ### 6. one stop solution to managing Data **Rating:** 4.5/5.0 stars **Reviewed by:** Heena R. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** May 30, 2023 **What do you like best about Amazon Redshift?** Its various usabilities, like ease to use and maintenance, its versatility to store humongous data, and its integration with various tools make it unique in its own way. **What do you dislike about Amazon Redshift?** Its usability and easy-to-maintain and integrated database have made it most desirable however when it comes to integrating data from different sources load time gets a bit slow. **What problems is Amazon Redshift solving and how is that benefiting you?** Insights generation is based on data sourced from different tools integrated and presented in a way that is beneficial to upscale the business and one can retrospect based on existing data to find shortcomings and eradicate them. ### 7. Amazon Redshift Use **Rating:** 5.0/5.0 stars **Reviewed by:** Gokul B. | Small-Business (50 or fewer emp.) **Reviewed Date:** October 16, 2023 **What do you like best about Amazon Redshift?** Convinent to use and easy to apply. Everyone should use! **What do you dislike about Amazon Redshift?** It takes some time while logging in, we can reduce that time **What problems is Amazon Redshift solving and how is that benefiting you?** Login ### 8. Best data store for storing the kpi's **Rating:** 5.0/5.0 stars **Reviewed by:** uday t. | Consultant (aws data platform), Mid-Market (51-1000 emp.) **Reviewed Date:** May 03, 2023 **What do you like best about Amazon Redshift?** Easy to create output tables Easy to querry the data inside the redshift tables uaing schema Can use multiple clusters so that we can use parellel processing of data at a time **What do you dislike about Amazon Redshift?** Cannot deal with huge data at once that was the reason for the reason for downtime for reducing the downtym we are implementing another data layer so that redshift clusters are always up **What problems is Amazon Redshift solving and how is that benefiting you?** Easy for storing kpi's Easy to create output tables based on schema Easy uo integrate with other aws services like s3 and glue Easy to create clusters and query the data ### 9. Best tool for faster querying **Rating:** 4.0/5.0 stars **Reviewed by:** Pramod Reddy Y. | Lead - Growth and User Acquisition , Small-Business (50 or fewer emp.) **Reviewed Date:** February 22, 2023 **What do you like best about Amazon Redshift?** Powerful and flexible data warehousing solution that can help organizations looking to store and analyze large amounts of data.This helps us organise data from mutliple sources and make sense of data. **What do you dislike about Amazon Redshift?** it is cost-effective solution for storing and querying large amounts of data for small amounts of data but it can become expensive when scaling up to larger data volumes and higher query rates. **What problems is Amazon Redshift solving and how is that benefiting you?** Redhshift store and manage large amounts of data from various sources, making it easier for me to analyze and gain business insights which is crucial in business decisions. ### 10. AWS Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** March 23, 2023 **What do you like best about Amazon Redshift?** Amazon redshift is very easy to use, with an intutive user interface that allows users to easily manage their data warehouses without any need for extensive technical knowledge. One of the best part of redshift is that it is highly scalable and it could scaled up to match changes in data volume. Amazon Redshift is highly scalable platform, you don't have to worry about scale and changes in data volume, redshift can handle it. Cost-Effective: Amazon redshift have pay as you go model which makes it a very good choice if your data is very dynamic and it can scale up or down according to y your needs and makes it a really cost-effective data warehousing platform. Security: For any datawarehouse security is a must and redshift handles it really well, the platform provides robust security features such as encryption, access control and audit logging. **What do you dislike about Amazon Redshift?** While I would say that amazon redshift is easy to use but it becomes complex as data volume and workload increases. Also it is optimised for batch processing of very large data but for ad-hoc and realtime analysis. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift helps us in solving business problems that includes storage and processing of huge piles of data. The query processing and it's optimisation makes Redshift a goto solution for users. ### 11. A powerful cloud-based data warehousing solution by AWS **Rating:** 4.5/5.0 stars **Reviewed by:** Germán Andrés C. | Content Marketing / Technical Writer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 02, 2023 **What do you like best about Amazon Redshift?** It allows businesses to store and analyze large amounts of data using a scalable, secure, and cost-effective platform; you can easily integrate data stored in RedShift with other tools in the AWS platform, like Quicksight and AI solutions. It has excellent performance in handling large datasets **What do you dislike about Amazon Redshift?** It may not be the best fit for every use case, and small businesses could find this solution expensive, so they must be careful with how they use it. **What problems is Amazon Redshift solving and how is that benefiting you?** We used Redshift to store large datasets which were used to create dashboards in Quicksight ### 12. Great experience with Amazon Redshift **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 22, 2023 **What do you like best about Amazon Redshift?** While using Redshift, given guided tour is very much helpful. It recommend and provides feedback with explanation after each small step you follow. This is very helpful for anyone to adopt Redshift, even with limited knowledge. **What do you dislike about Amazon Redshift?** Sometimes, choosing the resource options gets difficult, leading to higher costs. So, there should be some rough guidance around this. For example, selecting the space for a given file system should highlight how many similar files can be stored in the chosen option. **What problems is Amazon Redshift solving and how is that benefiting you?** Easy integration with the client's server. This helps create smooth ETL pipelines and a compatible analytics tool. Amazon started providing add-ons that help check/validate data as well to avoid any big noise. ### 13. Report for Redshift **Rating:** 4.0/5.0 stars **Reviewed by:** Saravanan M. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 10, 2023 **What do you like best about Amazon Redshift?** Easy integration with other AWS services, cost-effective and better performance for data reporting **What do you dislike about Amazon Redshift?** Initial complexity on setup this services,loading the data slowly **What problems is Amazon Redshift solving and how is that benefiting you?** Data compression for reporting,high performance ### 14. Best data warehouse among in competition **Rating:** 4.5/5.0 stars **Reviewed by:** Kashish M. | System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 24, 2023 **What do you like best about Amazon Redshift?** Best in every aspect price , scalability,integration and most important the brand which give me trust **What do you dislike about Amazon Redshift?** Not much to dislike but they can make more easy to Commit sql queries and everything their is great **What problems is Amazon Redshift solving and how is that benefiting you?** First it is very cheap as it is come with pay-as-you-go pricing structure and it can easiily handle massive datasets which gives great performance ### 15. Amazon Redshift is a solid cloud option **Rating:** 3.5/5.0 stars **Reviewed by:** Jack C. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2023 **What do you like best about Amazon Redshift?** It is great for being in the Amazon echo system (S3, Glu, Map Reduce, Elastic Search), and my understanding are the costs are linear (per node per environment) **What do you dislike about Amazon Redshift?** Will typically require more data engineer time and resources vs Snowflake (automated, managed solution with zero operational overhead to manage the underlying platform) **What problems is Amazon Redshift solving and how is that benefiting you?** Cloud data warehouse as an input for dbt (data build tool) ### 16. Amazon redshift at a glance **Rating:** 5.0/5.0 stars **Reviewed by:** Rakshith N. | Analyst , Retail, Enterprise (> 1000 emp.) **Reviewed Date:** April 18, 2023 **What do you like best about Amazon Redshift?** Scalibility where we can add or remove nodes to increase or decrease the computing power as and when needed. **What do you dislike about Amazon Redshift?** The cost of Amazon redshift is more and increases as we increase the size of the data warehouse. This is a common thing but when compared AWS could have offered it at much more lesser price **What problems is Amazon Redshift solving and how is that benefiting you?** All data warehouse capabilities for storing and analysing data. Also Amazon redshift supports SQL that is an advantage ### 17. Nice To have Redshift DB **Rating:** 3.5/5.0 stars **Reviewed by:** Veeresh G. | Small-Business (50 or fewer emp.) **Reviewed Date:** March 24, 2023 **What do you like best about Amazon Redshift?** Kind of redis, faster access we can use redshift **What do you dislike about Amazon Redshift?** sometime redshift auto-scalable feature need for Django Backend Integration **What problems is Amazon Redshift solving and how is that benefiting you?** We already use redshift for daily basis data access example, pricing of the product daily basis will change so this point of view we can use this redshift ### 18. Complicated but useful **Rating:** 2.5/5.0 stars **Reviewed by:** Rohan B. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 17, 2023 **What do you like best about Amazon Redshift?** It has variety of operations to manage data at any level ,all mechanisms are efficient and helps to process large data with lots of options.it enables data insights which can be used across business levels **What do you dislike about Amazon Redshift?** It's complicated and one really need to understand it throughout to perform data operations and sometimes it doesn't support cross table queries (for few databases) **What problems is Amazon Redshift solving and how is that benefiting you?** We used it in project where different database and different type of data was involved basically we wanted to gain some statistics where baseed on kind of unstruchered data and it worked for us ### 19. Amazing tool to scale your data **Rating:** 5.0/5.0 stars **Reviewed by:** Lokesh Kumar T. | Senior Software Development Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2023 **What do you like best about Amazon Redshift?** The scalability of Amazon redshift is perfect. For me the querying part of it is what it does its best. Followed by strong security features. **What do you dislike about Amazon Redshift?** Well it can't be use in cross/ multi cloud platforms like from aws to azure or back forth is what I fell like a let down. **What problems is Amazon Redshift solving and how is that benefiting you?** The main problem we face in a growing organisation is maintaining data of the customer and retaining their information. Redshift was the solution for us, since the scalability throughput boost is something great about it. The speed it takes scale the workloads are phenomenal. ### 20. Most effective data warehouse for olap operations **Rating:** 4.0/5.0 stars **Reviewed by:** K Madhusudan C. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 12, 2023 **What do you like best about Amazon Redshift?** Columar storage makes it more efficient and querying is easy since I am familiar with postgres **What do you dislike about Amazon Redshift?** Cost seems to bit more, creating a version for open source helps lot of people **What problems is Amazon Redshift solving and how is that benefiting you?** We were storing the events data mostly which helped us in doing some data analysis on top of that ### 21. Amazon Redshift to shift your data **Rating:** 5.0/5.0 stars **Reviewed by:** Bharath K. | Database Enterprise Analyst , Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** May 15, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift is a cloud data warehouse helping for etl, business intelligence and reporting. **What do you dislike about Amazon Redshift?** Nothing to dislike about Amazon Redshift except it's pricing **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift storing massive amount of data with good scalability and security solving many etl problems and providing maximum benefits when compared to onprem dw. ### 22. Amazon Redshift **Rating:** 4.5/5.0 stars **Reviewed by:** Himanshu B. | Junior Manager, Enterprise (> 1000 emp.) **Reviewed Date:** May 29, 2023 **What do you like best about Amazon Redshift?** The cost is based on the usage. And speed is good and easy to make workflows on matillion. **What do you dislike about Amazon Redshift?** Nothing specific that I feel is not good. **What problems is Amazon Redshift solving and how is that benefiting you?** Used it as data warehouse and build pipelines from landing, staging and publish layers. ### 23. Made it easy to analyse without all configuration **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Networking | Small-Business (50 or fewer emp.) **Reviewed Date:** September 19, 2023 **What do you like best about Amazon Redshift?** Fast and economical and really easy to use **What do you dislike about Amazon Redshift?** Query is limited and also database per unit is limited **What problems is Amazon Redshift solving and how is that benefiting you?** Easy to administrate ### 24. Cloud data housing at scale **Rating:** 4.5/5.0 stars **Reviewed by:** Uddipan M. | Engineering Manager, Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift provides cost advantages over other popular cloud data warehouses. It's scalable, available and easily integrates with AWS infrastructure. **What do you dislike about Amazon Redshift?** Storage and Compute is tightly coupled.. **What problems is Amazon Redshift solving and how is that benefiting you?** Cloud data warehousing and reporting support ### 25. Amazon Redshift **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.) **Reviewed Date:** September 05, 2023 **What do you like best about Amazon Redshift?** Data Engineering Speed Scalability Cloud Querying **What do you dislike about Amazon Redshift?** I think its expensive compared to Azure suite **What problems is Amazon Redshift solving and how is that benefiting you?** Data migration, Data integration and connecting to multiple dashboards ### 26. Solid platform with a few things that need improving for analytics usage **Rating:** 3.5/5.0 stars **Reviewed by:** Ray H. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 09, 2022 **What do you like best about Amazon Redshift?** Everything being contained in the AWS environment is a big plus. S3, Redshift, Spectrum, MWAA all working together and billed together. It's a lot easier to get approvals and such. It also has a lot of support with external tools such as dbt. **What do you dislike about Amazon Redshift?** There are some very specific problems related to my use case (analytics engineering). The documentation around SUPER fields was awful and it was hard to figure out how to use them. Also bizarrely there is no IF statement in Redshift queries. Comparing it to Presto, there are a lot less functions. **What problems is Amazon Redshift solving and how is that benefiting you?** It is very easy to connect Amazon Redshift to a lot of our tools such as dbt and Looker. It is unlikely I would work at a place that did not have their analytics database in the cloud. ### 27. Highly automated service **Rating:** 5.0/5.0 stars **Reviewed by:** Shubham K. | DevOps Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 25, 2023 **What do you like best about Amazon Redshift?** Highly automated service is definitely what I was looking for. **What do you dislike about Amazon Redshift?** There is nothing that one state as not likeable. **What problems is Amazon Redshift solving and how is that benefiting you?** Greatly scalable solution for big data storage that allows fast fetching of data for quick processing ### 28. Easy to setup, deploy, & manage. **Rating:** 4.5/5.0 stars **Reviewed by:** Perwaiz A. | Lead Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 14, 2023 **What do you like best about Amazon Redshift?** Easy to set up, deploy, & manage. Automated provisioning. **What do you dislike about Amazon Redshift?** Nothing, I like this product. Good experience. **What problems is Amazon Redshift solving and how is that benefiting you?** AWS Redshift is designed to handle large amounts of data and provides high performance and scalability ### 29. Fast and reliable **Rating:** 5.0/5.0 stars **Reviewed by:** Shivam J. | Data Engineer Intern, Small-Business (50 or fewer emp.) **Reviewed Date:** May 23, 2023 **What do you like best about Amazon Redshift?** That it's easy to use and has user friendly UI. **What do you dislike about Amazon Redshift?** Sometimes there are so many techs listed on aws website that's overwhelms us. **What problems is Amazon Redshift solving and how is that benefiting you?** It's helping me in storing big data easily and efficiently ### 30. Redshift: Best Data Warehouse Service from AWS **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** May 15, 2023 **What do you like best about Amazon Redshift?** If on AWS, Redshift is a great option for a data warehouse. For medium-sized data, this is a great way to manage, update tables. It works well with it's extension, Redshift Spectrum. **What do you dislike about Amazon Redshift?** Having always-on compute can be expensive if workloads are not consistent. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift has been a longstanding and helpful tool for us. It manages medium-sized data, and helps us make it available to all of the various customers and business stakeholders. ### 31. Very good MPP database in cloud. **Rating:** 4.0/5.0 stars **Reviewed by:** Bimarsh P. | Data Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** July 09, 2022 **What do you like best about Amazon Redshift?** With proper distribution style, compression, and data model, brings superior query performance. WLM queue is another great feature that helps manage the workload by provisioning proper memory allocation and concurrency levels for different user groups. **What do you dislike about Amazon Redshift?** Being the columnar database, the performance optimization technique is centered around the data colocation strategy using the proper distribution style. However, lack of ability to manage data in multiple partitions is sometimes challenging in scenarios where one needs to deal with a multi-tenant environment. Another challenge is a tradeoff between dense storage and dense compute nodes - in current days where storage has become very cheap, the storage cost of Reshift is still very high. Often it is difficult to choose between compute over storage or vice versa. **What problems is Amazon Redshift solving and how is that benefiting you?** The availability of high performant data warehouse in the cloud has helped many companies like ours get the best performance with a decent monthly budget, without spending thousands of dollars on managing expensive servers and licensing in the on-premise data center. ### 32. Advantages of redshift **Rating:** 4.5/5.0 stars **Reviewed by:** Abhirup M. | Database admin senior analyst, Enterprise (> 1000 emp.) **Reviewed Date:** April 18, 2023 **What do you like best about Amazon Redshift?** It is very faster due to columnar data storage. Easy to deploy code. Can be scaled quickly and most importantly is very secure. Cost effective. **What do you dislike about Amazon Redshift?** Redshift doesn't have any tool to ensure data uniqueness. There can be redundant data points. **What problems is Amazon Redshift solving and how is that benefiting you?** Code deploy in very less time. ### 33. Perfect tool for DWHs **Rating:** 5.0/5.0 stars **Reviewed by:** Iván R. | VP of Data, Small-Business (50 or fewer emp.) **Reviewed Date:** January 23, 2023 **What do you like best about Amazon Redshift?** Everything, the performance, management, and efficiency of the clusters are excellent, in addition to the integration with the rest of AWS services like S3 and Kinesis. **What do you dislike about Amazon Redshift?** The truth is that nothing in particular, maybe the only thing I miss is a specific client that matches everything it can offer, but as a tool itself, nothing to reproach. **What problems is Amazon Redshift solving and how is that benefiting you?** Provide a comprehensive solution to all the necessary requirements of a data warehouse, both in terms of storage and exploitation with business intelligence tools. ### 34. It's nice platform Software as Service **Rating:** 4.0/5.0 stars **Reviewed by:** Rajan Kumar Y. | Lead Machine Learning Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 28, 2023 **What do you like best about Amazon Redshift?** Redshift is awesome for handling semi-structured data in data warehouse and what i liked the most is exceptional support for ETL process. **What do you dislike about Amazon Redshift?** Integration and support for standalone tools like BDM **What problems is Amazon Redshift solving and how is that benefiting you?** We are using Redshift as Target platform with Informatica BDM for analysis of unstructured data which is coming from 5G telicom operators ### 35. Great Data warehouse product **Rating:** 3.5/5.0 stars **Reviewed by:** Ulka K. | Data Engineering Anayst, Enterprise (> 1000 emp.) **Reviewed Date:** December 21, 2022 **What do you like best about Amazon Redshift?** It offers ample amount of commands to be used especially for uploading of data to files. You can also use in to unload different types of files and in parts as well. **What do you dislike about Amazon Redshift?** It is very difficult to integrate it with other AWS resources as it invoices a lot od hustle woth security constraints and access issues. This can be simplified. **What problems is Amazon Redshift solving and how is that benefiting you?** It is great database warehouse. As the data is increasing day by day, it holds a lot of table with many datatypes. It has been very useful when analysing business data via a ETL process. ### 36. Redshift - Highly Scalable Low Latency Solution for Real Time Energy Efficiency Calculation **Rating:** 5.0/5.0 stars **Reviewed by:** Vignesh V. | Member Of Technical Staff III, Enterprise (> 1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Amazon Redshift?** It's highly scalable and offers low latency / managed cloud data management solutions for analytical workloads. The documentation is one of the best across cloud providers! **What do you dislike about Amazon Redshift?** I wish it could have offered better integrations with other data warehouses and data sources from different cloud providers/data center, which would be most needed to make multi-tenant setup easy for Analytical workloads, which is often from diverse sources and platforms. **What problems is Amazon Redshift solving and how is that benefiting you?** We needed a low latency and managed solution to make an efficient data warehouse and run analytics on top of these sources. It helps us by providing scalability managed by the cloud provider, and it's also cost-efficient in the long term. ### 37. good as analytics tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 20, 2023 **What do you like best about Amazon Redshift?** i found it's support to analysis data using sql way for structed & nom structured data **What do you dislike about Amazon Redshift?** i didn't find anything yet, it is actually gooad as industry standard **What problems is Amazon Redshift solving and how is that benefiting you?** our services is write havy service where we can't support daya read on any column for analytics purpose. so using this it make our life easier ### 38. Solution for big data analytics- Redshift **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Outsourcing/Offshoring | Mid-Market (51-1000 emp.) **Reviewed Date:** April 14, 2023 **What do you like best about Amazon Redshift?** It helps in performing analytics and gaining insight from the whole dataset rather than taking samples from the data and combining them, which may lead to erroneous insight. **What do you dislike about Amazon Redshift?** It is hard to train new individuals as it many of it's functions seem to be redundant and behind the times compared to it's competition. **What problems is Amazon Redshift solving and how is that benefiting you?** Make it easier for new users, that is richer documentation, more tutorial examples and overall better developer support ### 39. High performance, Less maintenance, Great product for small to medium scale data **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Small-Business (50 or fewer emp.) **Reviewed Date:** April 28, 2023 **What do you like best about Amazon Redshift?** Low on maintenance and Very easy getting started. **What do you dislike about Amazon Redshift?** Faced major breakdowns twice in 2 and half years. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift solves several problems related to data processing, storage, and management. Its high-performance, low maintenance, and scalable nature make it an ideal solution for organizations of all sizes, allowing them to focus on their core business operations without worrying about the complexities of managing their data ### 40. amazon redshift review **Rating:** 5.0/5.0 stars **Reviewed by:** Aisha S. | Senior BI engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** April 05, 2023 **What do you like best about Amazon Redshift?** when i used as a beginning it was very useful for me so i suggest everydone to do that **What do you dislike about Amazon Redshift?** i dont think there is any downside of redshift **What problems is Amazon Redshift solving and how is that benefiting you?** for Data integration it was very useful for me ### 41. Amazon redshift offers a hassle free experience in managing data **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** May 20, 2023 **What do you like best about Amazon Redshift?** Amazon redshift offers a reliable platform to manage semi-structured and structured data which makes data management and processing efficient **What do you dislike about Amazon Redshift?** I can't think of any of now. It offers pretty much everything needed to manage data efficiently **What problems is Amazon Redshift solving and how is that benefiting you?** By storing structured and semi structured data efficiently, applying business rules is hassle free ### 42. Good **Rating:** 4.0/5.0 stars **Reviewed by:** Vinay S. | Associate Database Administrator, Small-Business (50 or fewer emp.) **Reviewed Date:** March 15, 2023 **What do you like best about Amazon Redshift?** Easy to use and very scalable. It's a cost for effective service with fast. **What do you dislike about Amazon Redshift?** In this tables doesn't support column level privileges as per my observation. **What problems is Amazon Redshift solving and how is that benefiting you?** As it has parallel architecture using columnar storage solving so much of performance issues ### 43. Redshift Review - Rahul Agarwal (Data Scientist) **Rating:** 4.5/5.0 stars **Reviewed by:** Rahul A. | Associate Manager Data Scientist, Enterprise (> 1000 emp.) **Reviewed Date:** February 17, 2023 **What do you like best about Amazon Redshift?** Scalability and pay-per-use model are very cost-effective. **What do you dislike about Amazon Redshift?** Its not effective for real-time processing.First time setup is complex **What problems is Amazon Redshift solving and how is that benefiting you?** Scalability and movement to the cloud. We transferred our on-prem databases to Amazon Redshift which increased the productivity of my team. ### 44. Best experience **Rating:** 5.0/5.0 stars **Reviewed by:** Shamsher S. | Python Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 06, 2023 **What do you like best about Amazon Redshift?** Cost effective, easy deploy, streaming solution. **What do you dislike about Amazon Redshift?** Concurrent execution: Concurrent execution is a known challenge on MPP databases. **What problems is Amazon Redshift solving and how is that benefiting you?** Streaming solutions: The ability to scale is one of the most important aspects of a database, and Amazon Redshift is no different. ### 45. Amazon redshift review **Rating:** 4.5/5.0 stars **Reviewed by:** Ansu A. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** February 26, 2023 **What do you like best about Amazon Redshift?** The speed and set up ease are my favourite **What do you dislike about Amazon Redshift?** Migrating caused some issues in case which led to some shift being needed for the underlying user applications **What problems is Amazon Redshift solving and how is that benefiting you?** Storing multiple databases and environments in parallel. The connections are easy to manage and track. ### 46. Competitive offering **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Small-Business (50 or fewer emp.) **Reviewed Date:** December 01, 2022 **What do you like best about Amazon Redshift?** Fits great with in the AWS echo system. Provides great features and performance and a reasonable price. AWS keeps building tighter integration with other AWS ecosystem product such as Amazon Aroura with zero ETL which could be a big benefit for certain usecase. **What do you dislike about Amazon Redshift?** If you are concerned about vendor lock in that could be an issue. Not an open source system where you can migrate your workload easily to a different service provider. **What problems is Amazon Redshift solving and how is that benefiting you?** Ideal for traditional dimensional model data warehouse for structured data and works with a variety of viz tools such as tableau, power bi and traditional reporting tool. Easy user, developers and analysts transition experience into cloud Data warehouse from a traditional on prem sql server or oracle DB ### 47. Nice Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Enterprise (> 1000 emp.) **Reviewed Date:** May 21, 2023 **What do you like best about Amazon Redshift?** It is helpful to create Tables and views that serve as a backend for the Frontend tool **What do you dislike about Amazon Redshift?** It gets a little slow sometimes whenever commands are executed **What problems is Amazon Redshift solving and how is that benefiting you?** It is used as a backend ### 48. Perfect Fully managed dataearehousing service **Rating:** 4.5/5.0 stars **Reviewed by:** VINAY L. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 18, 2022 **What do you like best about Amazon Redshift?** Data backup, allowing to query bigdata without doing ETL(data from S3) **What do you dislike about Amazon Redshift?** Not as managed as Snowflake.. needs more manual work to setup things **What problems is Amazon Redshift solving and how is that benefiting you?** We use redshift for datawearehousing. We are saving on costs. Got good community support and easy to use ui, so we are benifitting with time ### 49. Best Data Analytics tool by AWS **Rating:** 4.0/5.0 stars **Reviewed by:** Pavankumar S. | Senior Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** February 07, 2023 **What do you like best about Amazon Redshift?** Two in one storage and analytics solution. Data can be managed in required format. **What do you dislike about Amazon Redshift?** Due to custom key creation performance gets impacted. Pricing also slightly higher side. **What problems is Amazon Redshift solving and how is that benefiting you?** We were using data analytics to create a graph based on user trend to understand the future orders. ### 50. Redshift on Real time data processing **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** May 08, 2023 **What do you like best about Amazon Redshift?** Efficient for data warehousing and ETL pipelining. **What do you dislike about Amazon Redshift?** It's not reliable for storing real time data as it creates deadlock conflict. **What problems is Amazon Redshift solving and how is that benefiting you?** For storing historical data and processing analysis on those data in batch is really a boon. ## 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=2§ion=pricing&secure%5Bexpires_at%5D=2026-07-03+22%3A25%3A26+-0500&secure%5Bsession_id%5D=2d74f218-4798-4108-b1fb-ad54f30bf11d&secure%5Btoken%5D=7e6d3fbcbc621b3eff83f7a20ddaccc056e89f80d8f4947c9ad3683d2c266cd4&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,145 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (708 reviews) - [Rocket Vertica](https://www.g2.com/products/rocket-vertica/reviews) - 4.3/5.0 (195 reviews)