--- 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-13' 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 commend the **fast querying capabilities** of Amazon Redshift, enhancing data analysis and efficiency significantly. (5 reviews) - Users value the **seamless integrations** of Amazon Redshift, enhancing data solutions within the AWS ecosystem efficiently. (5 reviews) - Users find Amazon Redshift's **ease of use** invaluable for data warehousing and seamless integrations with AWS services. (4 reviews) - Users appreciate the **easy integrations** of Amazon Redshift with the AWS ecosystem, simplifying data management and analytics. (4 reviews) - Users highlight the **impressive speed and scalability** of Amazon Redshift, efficiently handling massive data volumes and complex queries. (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, especially regarding advanced analytics and unstructured data support. (4 reviews) - Users face significant **software limitations** with Amazon Redshift, including performance issues and high costs at scale. (4 reviews) - Users find the **complexity of Amazon Redshift** challenging, with significant effort needed for optimization and maintenance. (3 reviews) - Users face **query issues** due to tuning needs, concurrency challenges, and limited support for unstructured data. (3 reviews) - Users find that **query optimization requires significant effort** , leading to increased operational complexity and management challenges. (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. 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. ### 2. DevOps point of view **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 22, 2023 **What do you like best about Amazon Redshift?** Easy to use while calling Redshift from application **What do you dislike about Amazon Redshift?** I have not face any difficulty while using redshift **What problems is Amazon Redshift solving and how is that benefiting you?** Our data was huge, so using redshift easy to manage ### 3. Great session **Rating:** 5.0/5.0 stars **Reviewed by:** Praveen K. | Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** November 04, 2022 **What do you like best about Amazon Redshift?** It is a great tool for fetching data and is having a great user interface. **What do you dislike about Amazon Redshift?** Some SQL function formats won't support in the redshift console. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift helps to store the client's data and it helps us in fetching the data whenever we need it for creating analysis. ### 4. Data Analytics Lead, AWS data analytics speciality certified **Rating:** 5.0/5.0 stars **Reviewed by:** Rushabh S. | Lead Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 08, 2022 **What do you like best about Amazon Redshift?** Redshift is cheaper data warehouse than most of the data warehouse in market. Easily scalable and can terminate and create servers on the go as per processing requirements. **What do you dislike about Amazon Redshift?** Like snowflake, redshift should have some more features. AWS should also create speciality certification specific to redshift since it is a very vast service. **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehousing solution made easy by AWS using redshift. It is very easy to use as compared to other warehouses in market. Also AWS documentation is best in the industry. ### 5. Good product **Rating:** 4.0/5.0 stars **Reviewed by:** Siddhartha C. | Analytics Architect, Enterprise (> 1000 emp.) **Reviewed Date:** January 05, 2023 **What do you like best about Amazon Redshift?** Easy to setup and provision. Very easy to connect from many types of client. **What do you dislike about Amazon Redshift?** The need to run maintenance jobs to clean up storage and enhance performance is a disadvantage. Storage management, runtime performance views and stats collection could be better. **What problems is Amazon Redshift solving and how is that benefiting you?** Analytics, reporting needs, data marts. ### 6. Amazon Redshift - A Real Shift towards Excellence **Rating:** 4.0/5.0 stars **Reviewed by:** Ashutosh K. | AVP, Small-Business (50 or fewer emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Amazon Redshift?** The flexibility and the simplicity of using this solution by anyone who is not so familiar with cloud infrastructure and how are they managed behind the scenes. **What do you dislike about Amazon Redshift?** The unique identity of the data being uploaded through distributed data sources does not gets taken care by Amazon Redshift. Other than that, if the data is being uploaded from other sources (except Amazon S3, relational DyanmoDBs), one would need to use some ETL solution or scripts to load the data. **Recommendations to others considering Amazon Redshift:** This is really a leader and a very user-friendly solution for the cloud-based data-warehouse needs. (Recommendation based on my usage as of now) **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift uses the same interface as PostgreSQL without the need of adapting to a new interface. Secondly, the speed that it offers loading, querying, analyzing or generating reports out of data. ### 7. Easy to use and robust!!! **Rating:** 4.0/5.0 stars **Reviewed by:** Vijayaraghavan Murugesan, B. | Data Analytics Manager, Enterprise (> 1000 emp.) **Reviewed Date:** August 05, 2022 **What do you like best about Amazon Redshift?** auto-suggestion options are good. so easy to write queries. **What do you dislike about Amazon Redshift?** Parallel uploading and enforcing uniqueness while inserting data is not available. **What problems is Amazon Redshift solving and how is that benefiting you?** Currently, I have eCommerce data lying in multiple systems. To analyze the data, I am extracting data using ETL process and storing all datasets in redshift database tables (each table has a million records then I wrote queries to join tables and performing my analysis. Hence I have data in one place and redshift is fast and robust I don't see any slowness. ### 8. Extremely user friendly platform **Rating:** 4.5/5.0 stars **Reviewed by:** Sahan W. | BI Consultant | Senior Engineer in Visual Analytics, Mid-Market (51-1000 emp.) **Reviewed Date:** July 24, 2022 **What do you like best about Amazon Redshift?** Amazon redshift is a cloud based platform which is user friendly, easy to work with and easy to catch up. And working with it is really interesting. Because, everything issue of a query is showing in a simple way. And efficiency of this is outstanding. Highly recmmended **What do you dislike about Amazon Redshift?** Would love a black theme . And if its there, it might be easy to work with and when working with large querries, the high contrast affect the eyes. So that wasnt a major issue. But just a suggestion **What problems is Amazon Redshift solving and how is that benefiting you?** Almost lot of tings having fixes. There is a good supporting team to save our back. So no need to worry. And if we arrive with an issue, we can easily google it and find a solution, ### 9. Redshift is a good choice for Data warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** MUKESH C. | Senior Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2022 **What do you like best about Amazon Redshift?** Multiple programming support is great, easy to maintain Database connections and add dashboards like Tableau, SAS & PowerBI. Also, Data sharing is easy. A cloud warehousing where is quite simple to add distinct sources and when we are maintaining s3 for storage, EMR for Big Data choice, then Redshift is a good option. **What do you dislike about Amazon Redshift?** Not a multi-cloud solution like Snowflake. The technical way I dislike is that we interact with only one node, i.e the master node, single point of failure can happen. **What problems is Amazon Redshift solving and how is that benefiting you?** We are storing huge bulk of data in Redshift. It ranges from 100 of GB to many TBs . We use EMR and EC2 services to interact with Redshift also external systems like SAS are easily configurable ### 10. Amazon Redshift DWH **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Mid-Market (51-1000 emp.) **Reviewed Date:** July 26, 2022 **What do you like best about Amazon Redshift?** We use Amazon Redshift as our DWH. We have set up several virtual machines on AWS for staging and production, which in turn are connected to Amazon Redshift for Database needs. We write all our scripts using Postgres SQL for redshift. **What do you dislike about Amazon Redshift?** Depending on which location your redshift cluster is located, the query execution time may differ. For eg: If users are running queries from a location far away from us-east-1, this could affect network speeds, which in turn affect the time it takes for results to load. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift is taking care of all our data warehousing needs. We use it in conjugation with a readymade pipeline (fivetran) and we haven't seen any issues with database availability or performance ### 11. Amazon Redshift Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Mid-Market (51-1000 emp.) **Reviewed Date:** July 18, 2022 **What do you like best about Amazon Redshift?** Especially for large-scale data processing as we have tables having terabytes of size and as our Data Pipeline uses multiple other AWS Services it has been the best data warehousing solution so far as it can spin up clusters in minutes. **What do you dislike about Amazon Redshift?** The maintenance required by Redshift cannot be automated, we have to work on data compression sometimes. We have to do regular data vacuuming as sometimes query performance is slowed down due to the high volume of data. **What problems is Amazon Redshift solving and how is that benefiting you?** Since Redshift is easy to set up, manage, and scalable we don't have to worry about storage and most of the time about query performance (making lives much easier). Especially its feature of using columnar storage makes its performance a lot better. ### 12. Amazingly fast & cost effective service **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 22, 2022 **What do you like best about Amazon Redshift?** Redshift is an Amazingly easy to configure, learn & quick to go market service. with a few clicks, your cluster is ready & If I compare the cost with other DW service providers like Snowflake or Synapse for that matter I feel redshift is the most cost-effective service. Its support for data lake via redshift spectrum is fascinating. I do recommend my client's Redshift compared to other cloud providers **What do you dislike about Amazon Redshift?** If we upscale cluster size, we end up spending lot more time bringing it up. Also more inbuilt Json data type support would be sweet to have. **What problems is Amazon Redshift solving and how is that benefiting you?** Moving enterprises to Lake architectures in conjunction with S3 & redshift spectrum helps organizations move faster to ML/Analytic use cases ### 13. Ideal for semi-structured large databases **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Small-Business (50 or fewer emp.) **Reviewed Date:** April 09, 2023 **What do you like best about Amazon Redshift?** Useful in querying large databases efficiently **What do you dislike about Amazon Redshift?** Not very useful for unstructured data or highly customized requirements **What problems is Amazon Redshift solving and how is that benefiting you?** Helps to query large structured databases with linkages ### 14. Some good things with some room for improvement **Rating:** 4.0/5.0 stars **Reviewed by:** Nisarg C. | Software engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 04, 2022 **What do you like best about Amazon Redshift?** The product is really good with good support in terms of documentation. **What do you dislike about Amazon Redshift?** Their ODBC driver is behind the times in the cloud data warehouse space **What problems is Amazon Redshift solving and how is that benefiting you?** Allowing customers to use their data in AWS space (S3 or redshift directly) ### 15. Best service provider **Rating:** 5.0/5.0 stars **Reviewed by:** Sagar C. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 19, 2022 **What do you like best about Amazon Redshift?** It is very easy to use with the best performance within minimum pricing while using Redshift. **What do you dislike about Amazon Redshift?** I don't see any cons so far in dislike of Amazon redshift. Everthing is just owsum. **What problems is Amazon Redshift solving and how is that benefiting you?** We are creating tables and views which easily accessable to all. Since data is stored on cloud so reduces the failure issues. Most of the Business problems gets solved using all the basic functionality of Redshift. ### 16. MVP data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** March 27, 2023 **What do you like best about Amazon Redshift?** MVP structure to handle large scale data **What do you dislike about Amazon Redshift?** Amazon redshift is not a server less architecture. **What problems is Amazon Redshift solving and how is that benefiting you?** Big data analysis. ### 17. I like Redshift and how powerful it is but what I miss are some features that exists in PostgreSQL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 04, 2022 **What do you like best about Amazon Redshift?** - Performance - Support - Documentation - Scalability **What do you dislike about Amazon Redshift?** - Missing PostgreSQL features - Pricing - When loading data, it doesn't support loading from local files - only for S3 **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehousing is what Redshift solves. It solves it acceptably with the seamless scaling features AWS provides ### 18. Powerfool tool to build your Data Warehouse and Data Marts. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** July 04, 2022 **What do you like best about Amazon Redshift?** 1. It is easy to use 2. Separate compute and storage nodes which help in cost optimization of resources. 3. Easy integration with AWS services 4. It has the ability to scale quickly. **What do you dislike about Amazon Redshift?** 1. Data is in the AWS cloud. So, some organizations might not want to save their data on the cloud. 2. Not so well suited for integration with services outside AWS. **Recommendations to others considering Amazon Redshift:** If you are on AWS cloud, there is no better tool than Redshift to build Data Warehouse. **What problems is Amazon Redshift solving and how is that benefiting you?** We can design and create our Data Warehouse and Data Marts on AWS redshift where we can query quickly and efficiently which results in better insights from data. ### 19. It is best cloud data warehouse and big data data platform for analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Mani Ratanam G. | Senior Accounts Executive, Small-Business (50 or fewer emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Amazon Redshift?** Easy for administration,ease of querying and Amazon Redshift Spectrum extends the capability of Redshift by allowing the system to scale compute and storage independent of each other. **What do you dislike about Amazon Redshift?** Satisfied with this but expecting little bit drop in price. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift has a similar querying language to the popular PostgreSQL. Anyone familiar with PostgreSQL can use their SQL skills to start engaging with Redshift Clusters. It is benefitting everyone. ### 20. Best performing cloud data warehouse to run and scale complex analytics on exabytes of data. **Rating:** 4.5/5.0 stars **Reviewed by:** AMIT C. | Program Analyst trainee, Enterprise (> 1000 emp.) **Reviewed Date:** August 03, 2022 **What do you like best about Amazon Redshift?** Running complex analytics without worrying about provisioning and managing infrastructure. An innovative cloud data warehouse with a lot of advanced features that can scale based on your workloads. **What do you dislike about Amazon Redshift?** Redshift is not a multi-cloud solution and only works within AWS. Concurrent execution of queries by multiple users sometimes slows down performance. Master node architecture causes the single point of failure challenge. **What problems is Amazon Redshift solving and how is that benefiting you?** It is helping us to analyze large and complex data with high performance without worrying about provisioning and managing infrastructure. Integration with AWS glue makes it a great fit for the cloud data warehouses. ### 21. It's from Amazon, so we can trust the security high availability **Rating:** 4.5/5.0 stars **Reviewed by:** Archana T. | Software Development Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2022 **What do you like best about Amazon Redshift?** Backup and recovery: it provides automatic recovery enable backup and recovery of database of specific define time. We can do it manually as well and I think backup and recovery is one of the most important feature of database **What do you dislike about Amazon Redshift?** Down time required for scaling operations which can be considered as dislike and we don't have any automatic performance tuning feature as well but still other features are great so no problem **What problems is Amazon Redshift solving and how is that benefiting you?** Providing me best platform for DBMS. Constant improvement to improve performance. I worked with other relational databases but nothing in compare to Amazon redshift ### 22. Cluster resizing is made effective thanks to Amazon Redshift Elastic Resize feature **Rating:** 4.0/5.0 stars **Reviewed by:** Bhavana G. | Cloud Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 18, 2022 **What do you like best about Amazon Redshift?** Amazon Redshift is vendor managed service offered by Amazon for our organization's data warehouse requirements. It's essential for our application clusters as it provides fast performance, excellent reliability, and outstanding scalability. I'm able to create or delete nodes in our application cluster easily, and it's feasible through both AWS management console and API calls. **What do you dislike about Amazon Redshift?** In Amazon Redshift, it isn't easy to work with nested structure requirements as there isn't much support offered for it. Except for this hurdle, we didn't come across any challenges while using Amazon Redshift in our enterprise. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift effectively implements Secure Socket Layer (SSL) encryption for establishing our cluster connection between our customer application and AWS platform. It optimizes our query performance with the aid of Massive Parallel Processing (MPP) feature, thereby also reducing computational time. Since it uses columnar storage, it provides superb efficiency in reading and writing data and also its quick retrieval. Cluster resizing is made fast and simple as we utilize its elastic resize capabilities to perform modifications within 15 minutes for our application. ### 23. Robust DWH **Rating:** 4.5/5.0 stars **Reviewed by:** Abhijat G. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 18, 2022 **What do you like best about Amazon Redshift?** Simple and responsive console. Unlike azure, Aws is seamless **What do you dislike about Amazon Redshift?** Price and cost per use. I think the pricing strategy should be revised. Particularly for reads **What problems is Amazon Redshift solving and how is that benefiting you?** It is working as a central data warehouse for our customer ### 24. Amazon Redshift is one of the best cloud warehouse solutions to handle large scale data. **Rating:** 5.0/5.0 stars **Reviewed by:** Parth C. | Data Scientist, Enterprise (> 1000 emp.) **Reviewed Date:** March 31, 2022 **What do you like best about Amazon Redshift?** Amazon Redshift provides the ease of working with large-scale data using SQL and getting the desired outputs in a fast-paced environment. It is widely adopted in comparison to its competitors and has great scalability. **What do you dislike about Amazon Redshift?** One of the drawbacks of Redshift is that it is only available on AWS, unlike other solution which are available on multiple cloud platforms. Also, when multiple users are querying, sometimes Redshift has performance issues. **Recommendations to others considering Amazon Redshift:** For anyone working as an analyst or data scientist and actively querying on large-scale data, Amazon Redshift is a must-try. **What problems is Amazon Redshift solving and how is that benefiting you?** I have used Tableau at Capillary Technologies and HP working as Business Analyst and Data Scientist respectively. I have found Amazon Redshift as a very reliable data warehouse solution to safely store data, connect multiple sources, and query on them. Redshift provides the ease of connecting data directly to visualization tools like Tableau and PowerBI, helping me in efficiently building meaningful dashboards for business leadership. ### 25. Improvements on Amazon Redshift **Rating:** 3.5/5.0 stars **Reviewed by:** Ravi kumar V. | Senior ETL Developer, Enterprise (> 1000 emp.) **Reviewed Date:** March 28, 2022 **What do you like best about Amazon Redshift?** Bringing up the nodes automatically as soon as the storage limit is reached. The concept of RA3 is amazing. but if you ask me to compare with other tools in the market redshift didn't mark the expectations. **What do you dislike about Amazon Redshift?** Migration from DS2 to RA3 nodes. I have almost 5+ years of experience using redshift. I know RA3 is fantastic and sounds like a competitor for Snowflake. Just imagine companies have invested there amount and data into a cluster and built so many reportings on top of it. Now recommending it to RA3, just souts out the cluster DS2 which was built or used initially is of no use. And slowly I feel redshift is loosing its importance in the Market. Companies who have there modules setup on AWS cloud might be intrested on it. But personally as a developer, i would recommend snowflake because of the UI they provide and data shares they have. Just a review on my experience, but kudos to the entire team who came with the vision of RA3. **Recommendations to others considering Amazon Redshift:** If you have only simple star and snowflake schema projects and data volume less than 10Tb. you can go ahead with Redshift **What problems is Amazon Redshift solving and how is that benefiting you?** We use Redshift DB for storing our finance and sales analytics reporting. ### 26. Amazon Redshift Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospitality | Small-Business (50 or fewer emp.) **Reviewed Date:** August 02, 2022 **What do you like best about Amazon Redshift?** Amazon Redshift is a cloud based platform where in you can extract almost all of your production datasets in one go. It helps us to avoid the dependency on other files which needs to be downloaded from websites etc. It is a good platform to link with Power BI, Tableau dashboards also. **What do you dislike about Amazon Redshift?** Due to the large volumes of data, the performance of data pull can be slow. Depending on where the server is located, the performance of queries can be affected. So the query performance expectations is varying for each region. **What problems is Amazon Redshift solving and how is that benefiting you?** All of the data needed for analysis can be extracted from one main source and due to this, we can avoid having so many dependencies. It is easier to refer everything to one source. ### 27. Analyze structured and semistructured data **Rating:** 5.0/5.0 stars **Reviewed by:** Sandip S. | Senior Advisory Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** September 02, 2022 **What do you like best about Amazon Redshift?** It is ideal for data lakes. Very easy for querying. Performance, scalability, security is very robust. Ease of administration is very good. Strong AWS ecosystem. **What do you dislike about Amazon Redshift?** Not a multi cloud solutions. Not fully managed. Concurrent execution is up to the mark. choice of keys impacts performance and price.it is not serverless architecture. price is to high. **What problems is Amazon Redshift solving and how is that benefiting you?** Real time analytics, combining multiple datasources, business intelligence, log analysis, speed is very good.Data encryption is best ### 28. Perfect replacement of on premise Greenplum data warehouse **Rating:** 4.0/5.0 stars **Reviewed by:** Rahul R. | Principal Data Architect & Lead AWS Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 27, 2022 **What do you like best about Amazon Redshift?** The way Redshift integrated with other AWS services is amezing. The best part is you don't need to worry about capacity management at the initial phase of the project. **What do you dislike about Amazon Redshift?** It requires more expertise to maintain the database as compared to Snowflake which also provide similar functionality as AWS Redshift. Hence Redshift have long learning curve **What problems is Amazon Redshift solving and how is that benefiting you?** As compared to other treditional database , Redshift can hendel data in petabyte. And one of the few places where you can implement "one big table" approach instead of dimensional modelling for faster implementation. ### 29. Experience of using Amazon Redshift **Rating:** 4.0/5.0 stars **Reviewed by:** Manpreet S. | Lead BI Specialist, Mid-Market (51-1000 emp.) **Reviewed Date:** August 05, 2022 **What do you like best about Amazon Redshift?** It has a slight learning curve and the documentation provided by the AWS team is very comprehensive and easy to understand. It is better than other products for processing massive data volumes. **What do you dislike about Amazon Redshift?** When multiple queries are running parallelly then the performance of Redshift degrades as the processing power is distributed. Hence, sometimes it takes hours for query execution. **What problems is Amazon Redshift solving and how is that benefiting you?** We use Amazon Redshift as OLAP that powers our products' analytical capabilities. All the KPIs and Dashboards/Reporting in our products use Redshift as the data source. ### 30. it's a best cloud data ware house, it has the best parallel processing, computing, scalable features **Rating:** 5.0/5.0 stars **Reviewed by:** Biswajeet S. | Data Analyst GAMMA, Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Amazon Redshift?** it has the best parallel processing, computing, scalable features are there. Also it can be easily connected with any BI platforms. Scalability and computing speed I like the most. **What do you dislike about Amazon Redshift?** Nothing in dislike for redshift, if price can be lesser it is good but still fine. **Recommendations to others considering Amazon Redshift:** UseAmazon Redshift cloud data warehouse instead of any on premise database i will suggest **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift is able to store our CPG client's inventory data and each transactions are happening successfully with it's incremental load features, also we use redshift connecting to BI tools to keep track of all transactions. ### 31. Amazon Redshift provides a great tool for aggregating disparate sources of data. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about Amazon Redshift?** Amazon Redshift allows me to pull information from many different sources, and query them like any other relational database. This is key for advanced analytics. **What do you dislike about Amazon Redshift?** A preview feature would be great when viewing a table or view. Currently, I have to execute a query, in order to see any of the data. In Oracle, it would show some of the data whenever I clicked on the table. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift provides a great back end to our reporting system. We can provide complex reports to our stakeholders that span multiple areas of our business. ### 32. Redshift helps us review massive data **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2022 **What do you like best about Amazon Redshift?** Redshirt allows us to quickly glean insights from our data. Having large datasets is hard **What do you dislike about Amazon Redshift?** The connectivity tools can be cumbersome. I hope that soon there are better frontend tools. **What problems is Amazon Redshift solving and how is that benefiting you?** Evaluating our customer service business unit. We use Redshift to assess several metrics across CS. Redshift is helping us refine our CS processes by illuminating weak points ### 33. Easy to handle Big data structured and un-structured both **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Management Consulting | Enterprise (> 1000 emp.) **Reviewed Date:** July 27, 2022 **What do you like best about Amazon Redshift?** It's a managed cloud data warehouse that easy to handle big data and it's very scalable that gives insights very fast and easily, It gives good security of data with high performance. It uses for infrastructure development and is easy to support with other apps and w3. **What do you dislike about Amazon Redshift?** sometimes is costable to handle the big data and it can be made easy to identify and learn. It has less capability to back up the data and we can't clone clusters easily. **What problems is Amazon Redshift solving and how is that benefiting you?** I got some scenarios based on truncate and incremental data so to manage that I use the redshift platform to manage integration and migration-based activities and mainly I used it for extract, transformation and load methodology accordingly I easily delivered my task. ### 34. Easy to manage Datawarehouse cluster **Rating:** 4.5/5.0 stars **Reviewed by:** Atmesh M. | AVP - Platform Engineering, Mid-Market (51-1000 emp.) **Reviewed Date:** March 04, 2022 **What do you like best about Amazon Redshift?** Redshift is easy to setup from scratch without any expertise in data engineering, we can scale out within minutes and with the use of AQUA, we can query large databases with ease. **What do you dislike about Amazon Redshift?** There are some issues concerning flexibility. The cluster options are limited to such an extent that even disk size is available in blocks per node. The concept of subnet cluster does not make sense. **Recommendations to others considering Amazon Redshift:** Test your use cases on a dev setup, make sure you have your success criteria fixed before using it. **What problems is Amazon Redshift solving and how is that benefiting you?** We have extensive data that we collect. We needed a warehouse to dump and query our structured data. Redshift helps us run analytics queries on top and accelerate our data-driven processes. ### 35. Great data warehousing solution **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 30, 2022 **What do you like best about Amazon Redshift?** Redshift is very fault tolerant which is great in the case of any unwanted event. **What do you dislike about Amazon Redshift?** It does not support parallel loading which kind of sucks since other DB services from AWS do. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift provides scalable yet secure data storage. This allows us to store our large amounts of data without concerns of security issues or outages. ### 36. Redshift for Your Data Platform Programs **Rating:** 4.5/5.0 stars **Reviewed by:** Rajeev S. | Data & Analytics Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** May 05, 2022 **What do you like best about Amazon Redshift?** The ease to sign up, spin up an instance and excellent performance for all data and analytics needs make Redshift my choice for cloud based data platform initiaves. Not only this, the ever expanding features of Redshift and interoperability makes it an awesome choice. **What do you dislike about Amazon Redshift?** There are few areas where Redshift is improving itself is getting rid of frequent table locking issues, on demand scalability. **What problems is Amazon Redshift solving and how is that benefiting you?** We used Redshift to be the backbone of our data platform to build DB hosted data lake and DW. We realised that whether data is within the base or on S3 you do not need to panick and plan for something else. Redshift will enable external tables on S3 based datasets as well. ### 37. Well equipped software **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 03, 2022 **What do you like best about Amazon Redshift?** Amount of data it can handle, strong download speeds, lots of customization **What do you dislike about Amazon Redshift?** Amazon has a lot of different applications to customize pipelines with, but sometimes these features should just be included in redshift **What problems is Amazon Redshift solving and how is that benefiting you?** Handling massive amounts of data, easy to transfer ### 38. Great experience in the summit and a great tool for data warehouse applications. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** December 13, 2022 **What do you like best about Amazon Redshift?** Fast performance Easy to set up, cost effective. Ability to scale up quickly. No upfront cost **What do you dislike about Amazon Redshift?** Not good for Oltp loads compared to snowflake. **What problems is Amazon Redshift solving and how is that benefiting you?** We need to set up new datawarehoue project. Redshift will definitely be very helpful for us ### 39. For beginners too it's the best. Easy to use. **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?** It provides the easy working with very large scale of data using Sequel and getting exact output in a fast paced workplace. It has the ability to scale quickly. **What do you dislike about Amazon Redshift?** It's high cost price than other is the only thing. Otherwise it's good. Also for the some outside serivices, it is not applicable for integration with it. We can design and create our data warehouse and data marts on Aws redshift where we can query quickly. **What problems is Amazon Redshift solving and how is that benefiting you?** I have seen that Amazon redshift are very reliable data warehouse solution to safely store data, connect multiple sources, and query on them. We can use Redshift DB to store our finance and sales analytics reporting ### 40. Amazon Redshift is superb. Helps in simplying problems **Rating:** 4.0/5.0 stars **Reviewed by:** Yash K. | Data Scientist II, Mid-Market (51-1000 emp.) **Reviewed Date:** July 04, 2022 **What do you like best about Amazon Redshift?** Easy to use. Helpful in scaling up without complications. Faster execution. Has great security **What do you dislike about Amazon Redshift?** It is not a multi cloud solution and as result can become a problem if a use case comes around for that. **Recommendations to others considering Amazon Redshift:** Great product. Go for it to effectively right queries and generate insights **What problems is Amazon Redshift solving and how is that benefiting you?** Administration is quite easy so it helps setting up the rules in the department. Also querying is very efficient as it is similar to postgres. So helps to solve problems and generate insights ### 41. First public cloud provider to offer cloud-based warehousing service. **Rating:** 4.5/5.0 stars **Reviewed by:** Rajat T. | Seller Partner Support Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** July 20, 2022 **What do you like best about Amazon Redshift?** It is ideal for data lakes. Increases performance and its scalability is very good. Security-wise, it is excellent. Ease of querying is there. **What do you dislike about Amazon Redshift?** It should be managed 100%. A multi-cloud solution should be present. Serverless architecture should be present. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Web Services (AWS) est le premier fournisseur de cloud public à offrir un service d'entreposage de données à l'échelle du pétaoctet basé sur le cloud. Le service s'appelle Amazon Redshift et est l'entrepôt de données cloud le plus populaire. ### 42. Very easy to set up **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Mid-Market (51-1000 emp.) **Reviewed Date:** March 25, 2022 **What do you like best about Amazon Redshift?** Easy to set up a data warehouse, especially if your current tech infrastructure already runs on AWS. Redshift is also readily supported by many other tools out there like Apache Superset. **What do you dislike about Amazon Redshift?** Max concurrency of 50 is too low to support a large organization which requires many concurrent users. Resizing is also quite challenging and can entail some down time. Elastic resize is neat but limited. Classic resize takes too long to finish. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift allows us to efficiently run analytic workloads on our ever-growing datasets. Significant time savings have been realized. Query run times have significantly improved, freeing up our data consumers for more valuable work. ### 43. Redshift for data engineers **Rating:** 4.5/5.0 stars **Reviewed by:** Mostafa T. | Data Ops, Mid-Market (51-1000 emp.) **Reviewed Date:** July 15, 2022 **What do you like best about Amazon Redshift?** Redshift spectrum service is one of my favorite as you can easily access simple storage service s3 data and query without replicating or copying the data into your cluster. **What do you dislike about Amazon Redshift?** Few kinds of data sources. But everything is good about it until now. **What problems is Amazon Redshift solving and how is that benefiting you?** The problem of data copying to the warehouse it's solved by spectrum. The speed of redshift and low latency make it near real time. ### 44. Amazing Experience **Rating:** 4.0/5.0 stars **Reviewed by:** Samaksh J. | Professional Services Specialist, Enterprise (> 1000 emp.) **Reviewed Date:** August 09, 2022 **What do you like best about Amazon Redshift?** The massive scope of parallel processing in the product. **What do you dislike about Amazon Redshift?** It is not a fully managed service and this solution is purely only on Amazon cloud not other clouds. **What problems is Amazon Redshift solving and how is that benefiting you?** Providing cloud data warehouse service with scope to handle petabytes of data. Managing large volumes of data on cloud is very easy with this. ### 45. One of the best cloud data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Kubendra Reddy M. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2022 **What do you like best about Amazon Redshift?** Best thing is its autoscaling and multi parallell processing architecture. we can easily scale up and down the cluster size based on our data size. Has many features such like to manage and monitor the jobs.It is more secure and allow us to encrypt our data too. **What do you dislike about Amazon Redshift?** It only runs on AWS and felt little costly when compared to other sata warehouse service providers. **Recommendations to others considering Amazon Redshift:** Best cloud data warehouse tool **What problems is Amazon Redshift solving and how is that benefiting you?** We are maintaining some of our health care data in Redshift. We have moved and processed the data from on premise servers to redshift for better performance. It saved our cost compared to traditional data warehouses. ### 46. Amazon Redshift: an amazing Data warehouse tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 23, 2022 **What do you like best about Amazon Redshift?** Redshift spectrum is a great tool which allows users to query against the S3 data without brining the data in Redshift this greatly enhances the overall productivity of the product **What do you dislike about Amazon Redshift?** When there is a situation of getting maxed out on onr of the clusters, the need to replicate data to multiple clusters ends up costing us too much. There should be a proper separation of storage and computation. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift enables you to expand your data warehouse queries to your data lake. It has massive parallel processing which enable it to provide lightening fast performances. ### 47. Best cloud data waamazon redshift has better computing scalability **Rating:** 5.0/5.0 stars **Reviewed by:** Jyotirmayee S. | Sap Materials Management Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about Amazon Redshift?** it's the best cloud data warehouse with best computing engines. I like it's processing speed and performance for SQL queries. Also I like it's connectivity with BI engineers. **What do you dislike about Amazon Redshift?** Nothing about dislikes,if pricing can lesser then it's good else it is fine. **What problems is Amazon Redshift solving and how is that benefiting you?** We use redshift data warehouse for oil gas industrie's sourcing and procurement, material requirement planning and warehouse management. ### 48. AWS redshift review **Rating:** 4.0/5.0 stars **Reviewed by:** harshit a. | Senior Business Intelligence Engineer - AWS Devops, Enterprise (> 1000 emp.) **Reviewed Date:** March 31, 2022 **What do you like best about Amazon Redshift?** 1. Super easy UI 2. The feature to kill running queries. 3. Dashboard to monitor health of the cluster 4. WLM user query groups. 5. Backup and restore 6. Excellent customer support **What do you dislike about Amazon Redshift?** I have not come accross any disadvantages or short commings till yet. **Recommendations to others considering Amazon Redshift:** Highly recommended **What problems is Amazon Redshift solving and how is that benefiting you?** We are dumping data from various applications into redshift which is used as a data source to perform analytical operations on all the etl tools. ### 49. Redshift is flexible & easy to use **Rating:** 3.5/5.0 stars **Reviewed by:** RAJ K. | Lead Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** July 21, 2022 **What do you like best about Amazon Redshift?** We can store DB as a snapshot and switch it on & off when we need it, we can apply the same SQL Query here. **What do you dislike about Amazon Redshift?** The complex queries in SQL can need many tweaking while using redshift. **What problems is Amazon Redshift solving and how is that benefiting you?** Database operations, upscale the server as when needed and downscale when not needed, fast quering ### 50. Redshift as Data ware house service **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 04, 2022 **What do you like best about Amazon Redshift?** I used redshift to analyse data collectively. I migrated data from various data sources like RDS MySQL,PSQL and MongoDB and so on. So once i had data from this all data sources, I was able to run AND statement queries in redshift to analyse this collective data. **What do you dislike about Amazon Redshift?** It's not that cost efficient unless and until you purchase reserved instances. **What problems is Amazon Redshift solving and how is that benefiting you?** It helped to run AND statement queries on the migrated data which was present in different data sources to analyse data. ## 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=3§ion=pricing&secure%5Bexpires_at%5D=2026-07-13+14%3A21%3A35+-0500&secure%5Bsession_id%5D=27ab95ff-7667-4ed0-bb86-64d5da1ba88a&secure%5Btoken%5D=a4079c5599dac70c206197e7b3799e4e9991b219070c8a164400c0f2449bd285&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 (707 reviews) - [Rocket Vertica](https://www.g2.com/products/rocket-vertica/reviews) - 4.3/5.0 (195 reviews)