# 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 praise the **fast querying** capabilities of Amazon Redshift, enabling smooth and efficient data handling on a large scale. (5 reviews) - Users value the **seamless integration** of Amazon Redshift with other software and AWS services for efficient data solutions. (5 reviews) - Users value the **ease of use** of Amazon Redshift, enjoying its user-friendly interface and smooth data management. (4 reviews) - Users value the **easy integrations** of Amazon Redshift, enhancing their experience by streamlining data workflows and solutions. (4 reviews) - Users praise Amazon Redshift for its **exceptional performance and scalability** , effectively handling large data volumes with speed. (4 reviews) - Users appreciate the **scalability** of Amazon Redshift, enabling seamless handling of large data volumes and efficient analytics. (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, particularly in advanced analytics and cross-language support. (4 reviews) - Users note **significant software limitations** with Redshift, particularly regarding performance tuning and unstructured data support. (4 reviews) - Users face significant **complexity in optimization and maintenance** for Redshift, impacting overall performance and usability. (3 reviews) - Users face challenges with **query performance and optimization issues** , complicating effective database usage and management. (3 reviews) - Users face the **time-consuming query optimization** process, requiring significant effort and specialized knowledge for effective tuning. (3 reviews) - Difficult Management (2 reviews) - Expensive (2 reviews) - Integration Issues (2 reviews) - Learning Difficulty (2 reviews) - Performance Issues (2 reviews) ## Amazon Redshift Reviews ### 1. Powerful Analytics Tool with Some Flexibility Limitations **Rating:** 4.0/5.0 stars **Reviewed by:** Atharva P. | Cloud BI Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 08, 2026 **What do you like best about Amazon Redshift?** I like Amazon Redshift because it solves large-scale data warehousing and analytics challenges by providing a centralized platform for storing and querying massive datasets. It enables faster reporting and better business insights, offering scalable analytics for enterprise workloads. I also appreciate its tight integration with AWS and its AI features, like automated workload management and query optimization. **What do you dislike about Amazon Redshift?** Cluster sizing, tuning, and cost optimization require very careful management. Performance can degrade if distribution keys and sort keys are not designed properly. Not very flexible as compared to Snowflake or BigQuery. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift solves large-scale data warehousing and analytics challenges. It provides a centralized platform for storing and querying massive datasets, enabling faster reporting and better business insights, with scalable analytics. It's tightly integrated with AWS and offers strong SQL support and high query performance. ### 2. Scalable and Efficient Cloud Data Platform **Rating:** 4.5/5.0 stars **Reviewed by:** Swaroop W. | Senior IT Project Manager - Senior Scrum Master, Mid-Market (51-1000 emp.) **Reviewed Date:** May 26, 2026 **What do you like best about Amazon Redshift?** Amazon Redshift provides excellent performance for large-scale data warehousing and analytics workloads. I like its seamless integration with AWS services, fast query execution, scalability, and ease of managing huge datasets. The pricing flexibility and support for BI/reporting tools make it very useful for enterprise analytics solutions **What do you dislike about Amazon Redshift?** The main downside is that query optimization and cluster management can be complex for beginners. Costs can increase quickly if resources are not monitored and optimized properly **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift helps us solve large-scale data analytics and reporting challenges by centralizing data from multiple systems into one platform. It improved query performance, reduced report generation time from hours to minutes, enabled real-time insights, and optimized infrastructure costs through scalable cloud architecture. ### 3. Fast, Scalable Data Warehouse with Strong AWS Integration **Rating:** 5.0/5.0 stars **Reviewed by:** Ankit K. | Business Analyst, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** March 17, 2026 **What do you like best about Amazon Redshift?** fast query performance on large datasets, scalable data warehouse, strong integration with AWS ecosystem, columnar storage for analytics, good for structured data workloads, reliable for reporting and BI **What do you dislike about Amazon Redshift?** query performance can degrade without optimization, concurrency limitations on heavy workloads, maintenance and tuning effort required, scaling is not fully seamless, cost can increase with usage **What problems is Amazon Redshift solving and how is that benefiting you?** centralized data warehousing, faster analytics on large datasets, improved query performance for reporting, better integration with BI tools, enables data-driven decision making ### 4. Powerful Data Warehousing with Speed, but Lacks Out-of-the-Box Optimizations **Rating:** 3.5/5.0 stars **Reviewed by:** Rishav M. | Data Engineer 2, Mid-Market (51-1000 emp.) **Reviewed Date:** October 13, 2025 **What do you like best about Amazon Redshift?** What I like best about Amazon Redshift is its ability to handle massive amounts of data with impressive speed and scalability. It’s designed specifically for data warehousing, so complex queries run efficiently thanks to its columnar storage and massively parallel processing (MPP) architecture. Plus, it integrates smoothly with the AWS ecosystem, making it easier to build end-to-end data solutions accompanied by existing backend infrastructure. **What do you dislike about Amazon Redshift?** In terms of optimizations, there are very little things that come out of the box. A significant amount of effort is required to optimize Redshift. - We have to manage the clusters and nodes since its not a serverless solution (not talking bout spectrum here!) - Concurrency issues when it is being used by a large number of users. We've had to set up limits and checks in place separately, which is a bit annoying. - There's a lot of maintenance overhead. Tasks like vacuuming and analyzing tables to maintain performance still require attention and adds lots of operational complexity. **What problems is Amazon Redshift solving and how is that benefiting you?** In my previous companies, we decided to build out a pandas based reporting solution on top of a data warehouse. We had billions of rows of historical retail data which was ingested into Redshift from our OLTP systems via DMS. We chose Redshift for this since we were already in an AWS environment and it offered easy integrations. - Redshift's columnar nature helped in crunching and aggregating huge data volumes, making it ideal for our reporting solutions. - There are some nice optimizations like sort keys and distribution keys and vacuuming which helps to query the data faster. Though this takes quite some time to set up. - New improvements like Redshift Spectrum also help in querying raw data residing in S3 buckets for adhoc use cases. Overall, I've been satisfied with the product for usecases with small-to medium size data load. ### 5. Easy Integration with Amazon Redshift for Fast Data Queries **Rating:** 4.5/5.0 stars **Reviewed by:** Anup K. | Business Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** February 19, 2026 **What do you like best about Amazon Redshift?** It’s easy to integrate with other software, works well with Amazon Redshift, and makes it fast to query data. **What do you dislike about Amazon Redshift?** ui can be more interactive as right now everthing look clustered **What problems is Amazon Redshift solving and how is that benefiting you?** we uses aws datawarehouse and currently work faster when we have query without joins ### 6. Reliable and scalable data warehouse with room for improvement **Rating:** 4.5/5.0 stars **Reviewed by:** Kathy L. | Director, Mid-Market (51-1000 emp.) **Reviewed Date:** August 27, 2025 **What do you like best about Amazon Redshift?** Amazon Redshift provides excellent scalability for handling large volumes of structured data and integrates smoothly with other AWS services like S3 and Glue. Query performance is strong for analytical workloads, and the columnar storage significantly speeds up aggregation queries. The ability to separate storage and compute has improved cost management and flexibility, making it easier to scale resources up or down depending on workload needs. **What do you dislike about Amazon Redshift?** While powerful, Redshift can become costly at scale if not carefully monitored and optimized. Query performance sometimes degrades when dealing with complex joins or semi-structured data compared to newer cloud-native solutions. Managing concurrency can also be a challenge, and performance tuning requires specialized knowledge. Additionally, native support for unstructured data is still limited compared to alternatives. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift helps consolidate data from multiple sources into a centralized data warehouse, making it easier to run analytical queries at scale. This has allowed our team to generate business insights much faster compared to traditional databases. By leveraging its integration with AWS services like S3 and Glue, we’ve automated our ETL pipelines, reduced manual data preparation, and improved reporting speed. It has also helped optimize decision-making by giving stakeholders near real-time access to dashboards and analytics. ### 7. Good Product **Rating:** 5.0/5.0 stars **Reviewed by:** Manh N. | Inventory Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** July 29, 2025 **What do you like best about Amazon Redshift?** What I like best about Amazon Redshift is how easy it is to connect and get started. The interface is user-friendly, and the connection is fast, which makes querying large datasets smooth and efficient. **What do you dislike about Amazon Redshift?** "So far, I haven’t encountered anything I dislike about Amazon Redshift. It’s been reliable and has met my needs well. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift makes it way easier to handle and analyze large amounts of data without everything slowing down. I can run big queries and get results fast, which really helps when I need to make decisions quickly or build reports. It also pulls data from different sources into one place, so I don’t have to waste time jumping between tools ### 8. Easy to Use, Scalable, and Simple to Connect with Other Software **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Utilities | Mid-Market (51-1000 emp.) **Reviewed Date:** March 16, 2026 **What do you like best about Amazon Redshift?** Easy to use, scalable, easy to connect to other software **What do you dislike about Amazon Redshift?** Sometime sis hard to translate the data types from other RDBMS but usually you can find a way to sync them **What problems is Amazon Redshift solving and how is that benefiting you?** We are using it as a datawarehouse in the project I'm on ### 9. Easy to scale up and down, cost effective and easy to integrate with EMR and lambda **Rating:** 5.0/5.0 stars **Reviewed by:** Antarix K. | AI Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** October 12, 2025 **What do you like best about Amazon Redshift?** Easy to scale up and down, Multi zone architecture for data safeguarding. Easy to scale schedule. Easy logs access. Easy to setup and simple to inject data using EMR and lambda and Auto Sharing is great help. **What do you dislike about Amazon Redshift?** Query queuing and concurrency issues.At times Auto distribution style does not work wonders and needed to be changed. **What problems is Amazon Redshift solving and how is that benefiting you?** Data ingestion and massaging and manipulation for serving BI reports and ML models to use train on. ### 10. Amazon Redshift: Feature-Rich Cloud Data Warehouse with Excellent Support **Rating:** 3.5/5.0 stars **Reviewed by:** Yogesh K. | Senior software engineer 2, Enterprise (> 1000 emp.) **Reviewed Date:** October 23, 2025 **What do you like best about Amazon Redshift?** cloud-based data warehousing service, easy to access and manage, great support, lots of features, available to be integrated and used with many other platforms **What do you dislike about Amazon Redshift?** higher cost, few limitations to some data types **What problems is Amazon Redshift solving and how is that benefiting you?** flexibility and easy of usage of data at one place to be managed efficiently solving the problem of looking for multiple options for one problem ### 11. Amazon Redshift: Powerful and Scalable Data Warehousing for Seamless Analytics **Rating:** 4.0/5.0 stars **Reviewed by:** Prakash G. | Data Migration Specialist, Data Engineering Manager, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** November 15, 2024 **What do you like best about Amazon Redshift?** Amazon Redshift has an easy to use and setup gives teams of all sizes access to data warehousing and analytics. It’s got robust feature and it integrates well with other AWS services to make it easy to implement and scale. Their customer support is reliable and their use frequency adds a value by using their analytics which give us important insights about our business. **What do you dislike about Amazon Redshift?** While powerful, Amazon Redshift can be expensive to process on a large scale with increasing amount of data. Complex joins can slow down query performance, and tuning is an expertise. In high demand environments there is limited support for unstructured data and frequent optimization can be difficult, especially for daily operations. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift helps satisfy our demand for fast data warehousing by giving us blazing fast query performance in large datasets to run daily reporting and analytics. While complex data queries can occasionally be performance challenging, it provides our center data, which in turn helps us to gain better insights, and better decisions which in turn helps in our business operation and strategy planning. ### 12. High-Performance Data Warehousing with Exceptional Scalability **Rating:** 5.0/5.0 stars **Reviewed by:** Snehasish K. | Founder, E-Learning, Small-Business (50 or fewer emp.) **Reviewed Date:** October 30, 2024 **What do you like best about Amazon Redshift?** Amazon Redshift is a game-changer, allowing us to have highly scalable and performance-enabled data warehousing for the complex project. The MPP architecture and columnar storage offer powerful query performance on the platform. Redshift also allowed us easily to integrate several AWS services, such as using S3 for data imports and Glue for ETL operations, and made our pipeline very streamlined so that data transfer and queries were decreased by many times. With Spectrum, Redshift can handle structured as well as semi-structured data, which will allow efficient cross-database queries and productivity boost with regards to data analytics and reporting. Advanced data compression features and data distribution ensure that storage is optimally utilized while efficiently making use of and managing costs on resources. **What do you dislike about Amazon Redshift?** Though performance and scalability of Redshift are excellent, the system is not very easy to use for optimization and query tuning for new users. Automated tools for better configuration will enable it to reach a diverse set of teams. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift solved the problem of big data processing and execution of complex queries by offering a strong and reliable infrastructure that accelerates data processing by up to 35%. Its scalable power has helped absorb increasing volumes of data, and rich analytics support has been helpful in helping you experiment quickly and bring actionable insigh ### 13. Reliable and Powerful Data Warehousing **Rating:** 5.0/5.0 stars **Reviewed by:** Jai C. | Software engineer , Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** March 19, 2024 **What do you like best about Amazon Redshift?** Whenever I need to manage large datasets, Amazon Redshift is my go-to tool. Its ability to handle complex queries and large volumes of data makes it essential for my work. The speed and efficiency with which it processes data are particularly impressive. **What do you dislike about Amazon Redshift?** For someone new to AWS or cloud-based data warehousing, getting started with Redshift can be a bit tricky. The initial learning curve was steep for me, especially when it came to understanding the migration process. But with time, I found it to be an invaluable platform for analyzing complex data. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift has been a crucial tool for managing financial data and forecasting demand. I appreciate how it simplifies data sharing within my team and integrates smoothly with tools like Microsoft PowerBI and Tableau. This integration has allowed me to create detailed reports and dashboards that are easy to use and share, streamlining our workflow. ### 14. Excellent product, highly recommend **Rating:** 5.0/5.0 stars **Reviewed by:** Shehriyar A. | Search Engine Optimization Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** June 24, 2025 **What do you like best about Amazon Redshift?** Scalable tools with real-times insights. **What do you dislike about Amazon Redshift?** please Pricing can be complex and unclear. **What problems is Amazon Redshift solving and how is that benefiting you?** Handles big data with fast insights ### 15. A complete data warehouse solution with scalability **Rating:** 4.0/5.0 stars **Reviewed by:** Happy M. | Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 21, 2024 **What do you like best about Amazon Redshift?** It provides easy to use and implement yet very powerful columns based data solution that helps in faster query performance. Also cross database analytics is gamechanger. **What do you dislike about Amazon Redshift?** It requires time for propely optimizing and tuning queries for the db which is the downside of this solution. **What problems is Amazon Redshift solving and how is that benefiting you?** It has made possible to manage multiple cross db data processing with ability to run complex db queries on that data. I helps in analysing the data stored from different db and get proper insights of it. ### 16. Okay cloud data warehouse If you are existing AWS customer **Rating:** 2.5/5.0 stars **Reviewed by:** Rijul S. | Lead Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 15, 2024 **What do you like best about Amazon Redshift?** Comes with AWS suite of Saas extremely secure cloud data warehouse Medium level of complexity for integration and usability Customer support is Fast and efficient can be used for daily and hourly usage never shuts down , unles there is global outage implementing can be tricky based on your existing use case **What do you dislike about Amazon Redshift?** IAM roles is very complex and not easy to integrate Slower than other cloud data warehouse **What problems is Amazon Redshift solving and how is that benefiting you?** Cloud Saas. comes with existing AWS suit so easy to integrate with existing cloud solutions example EC2. On premise to Cloud solution it solves. connecting with S3 datalake is easy and removes the extra layer problem as S3 is also part of AWS suite ### 17. A smooth experience with this Data Warehouse **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 23, 2023 **What do you like best about Amazon Redshift?** The best part is the ability of its keys (distribution data keys) which enhances the performance capabilities when queries are run. It is mostly managed by AWS and quite good in distribution processing too. Huge amount of data can be stored within it with ease, seamlessly integrates with other AWS services if needed, especially storage services. **What do you dislike about Amazon Redshift?** An option to search/find data would be a little helpful because it can have massive amount of data. Scalability whether up or down is restricted or to be precise, it is limited to an extent.= compared to other cloud providers. Even is concurrency is less compared to others with a max of 50. **What problems is Amazon Redshift solving and how is that benefiting you?** It helps in data storage and data processing all on cloud with very less downtime or issues. Caters us to provide data via queries for further usage like Reporting,further processing or even ETL for that matter to build pipelines. Stable at any point of time when used so it is reliable. ### 18. Best datawarehousing solution **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Mid-Market (51-1000 emp.) **Reviewed Date:** August 12, 2025 **What do you like best about Amazon Redshift?** Scalability and AI capabilities are very useful **What do you dislike about Amazon Redshift?** Lack of cross language usage for writing code **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehousing solutions and etl end to end ### 19. Great data warehouse solution **Rating:** 4.5/5.0 stars **Reviewed by:** matias d. | CRM & Lifecycle Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** December 18, 2024 **What do you like best about Amazon Redshift?** It has a great pay as you go pricing which is useful for small companies and has amazing performance with little issues. **What do you dislike about Amazon Redshift?** While Redshift is excellent for traditional data warehousing tasks, it lacks some of the more advanced analytics and machine learning features that are increasingly in demand. **What problems is Amazon Redshift solving and how is that benefiting you?** We use ir for data storage and to connect it to other platforms. ### 20. Best for Data Warehosuing **Rating:** 5.0/5.0 stars **Reviewed by:** Sourabh V. | Senior Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 03, 2024 **What do you like best about Amazon Redshift?** In Redshift we can show large amount of data using aws data glue crawler serviece easily. **What do you dislike about Amazon Redshift?** There is nothing now. its good for my use **What problems is Amazon Redshift solving and how is that benefiting you?** due this we can store our large amount data easily and we can do query in very less amount of time compare then other. ### 21. Amazon Redshift Review **Rating:** 4.5/5.0 stars **Reviewed by:** Vijay K. | Senior Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** February 06, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift is one of the best data warehouse platforms provided by AWS. It uses SQL to analyze structured, semi-structured, and unstructured data on the managed servers, so you don't have to worry about infrastructure and hardware maintenance. **What do you dislike about Amazon Redshift?** It can be a bit complex for new users to AWS or using other cloud providers data warehouse services. Also, migrating to Redshift can be tricky, but overall it's a great platform to gather insights and perform operations on multi-dimensional data. **What problems is Amazon Redshift solving and how is that benefiting you?** It can help with financial and demand forecasts and share the data with different team members under one access. It helps with data storage, transformation, business intelligence, and an increase in productivity. Ingest, perform ETL operation (Extract, Transform, Load), and integrate with 3rd party applications like Microsoft PowerBI, Tableau, or Amazon QuickSight to build real-time reports and interactive dashboards. It helped the team perform end-to-end operations from data integration, cleaning, machine learning model training, and generating business intelligence reports. Collaborative work, optimization of workloads, and forecasting are some of the benefits we observed. ### 22. Very good data storage for huge quantities of data **Rating:** 5.0/5.0 stars **Reviewed by:** Blas C. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 22, 2024 **What do you like best about Amazon Redshift?** Is very powerfull to store big quantities of data **What do you dislike about Amazon Redshift?** Sometimes is slow depending on the queries you use so you need to use other services for some use cases. **What problems is Amazon Redshift solving and how is that benefiting you?** Is serving as central place to store and query data coming from different sources ### 23. A perfect SQL based database for your data warehouse! **Rating:** 5.0/5.0 stars **Reviewed by:** Filippo C. | Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2023 **What do you like best about Amazon Redshift?** It'really easy to create and manage tables on Amazon Redshift. SQL syntax is simple and well documented and really helps me to query and aggregate the data. A wide range of data types are supported, even geometry data type for geo applications. **What do you dislike about Amazon Redshift?** I don't really have any big trouble in Amazon Redshift. A minor hiccup is that you have to carefully keep costs under control since it's not a cheap database. Furthermore, Materialized Views (still helpful) could be improved and made more flexible. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift is helping me to store aggregated data for further use, like reporting and data visualization. It supports connectors with the latest data visualization tools like Tableau and it's one of the best datasources available. ### 24. A reliable data warehouse for business insights **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2024 **What do you like best about Amazon Redshift?** Redshift provides scalable solution for large data warehouse. Import function using S3 bucket file as staging medium gives me an easy and fast way to build data pipeline. **What do you dislike about Amazon Redshift?** For small business, Redshift minimum prices is quite high, considering we don't need unique capabiilties that Redshift provides. **What problems is Amazon Redshift solving and how is that benefiting you?** We need a tool to consolidate data from various data sources, internal and external. With easy pipeline using S3, we can pretty much push any data into Redshift. ### 25. Best in Class solutions for cloud storage solutions and ease of access to connect with 3P software **Rating:** 4.5/5.0 stars **Reviewed by:** Dhruv S. | Specialist, Enterprise (> 1000 emp.) **Reviewed Date:** August 16, 2023 **What do you like best about Amazon Redshift?** Ability to connect with all data mining, data processing, data wrangling, data visualization tools like Alteryx, Celonis, PowerBI, Tableau, Talend and many more. Hassle free connection and optimal solution for small or big organizations **What do you dislike about Amazon Redshift?** Pricing is high for small business but worth the cost. Need skilled professional to maintain and create buckets and data warehouse management. Structure of the data lake is good but sometimes gets tough to maintain. **What problems is Amazon Redshift solving and how is that benefiting you?** It helps to maintain the big data from multiple verticals of the company, the input talend platform integration help to clean and scub the data. Proper structuring of data helps to properly maintain and store the data. With the help and extension with external softwares using FTP help eas integration. ### 26. My experience with Amazon Redshift **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** April 05, 2024 **What do you like best about Amazon Redshift?** Best things i like about Amazon Redshift is its speed compare with other data warehouses. Here we can easily handle big data. **What do you dislike about Amazon Redshift?** Nothing too much as of now, but when i was working on Redshift Data warehouse. I observed that little more improvement is neeed in data handling part like automatic data compression. **What problems is Amazon Redshift solving and how is that benefiting you?** In my project main problem was the speed for big data. Amazon redshift was able to solve speed problem compare to other data warehouse. ### 27. My first project with Amazon Redshift **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** April 04, 2024 **What do you like best about Amazon Redshift?** the one thing i feel about Amazon Redshift that it is very easy to use and can write regular sql query in this. Also it is very fast compare with other databases. **What do you dislike about Amazon Redshift?** Nothing as of now, just a liitle improvement is needed in the UI/UX for easy interation with the user. **What problems is Amazon Redshift solving and how is that benefiting you?** when i was using Snowflake for my project. it was not satifying my speed need and shifting to Amazon redshift solve the issue for this project. ### 28. Powerful Data Warehousing Solution **Rating:** 4.5/5.0 stars **Reviewed by:** Sonny C. | Head of Cloud and Data Business, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** September 11, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift is a game-changing data warehousing solution that has transformed the way businesses handle their data analytics and reporting needs. As the Head of Cloud business in our organization, I have had the opportunity to work extensively with Redshift for our customers, and I can confidently say that it is a top-notch product that offers exceptional performance, scalability, and ease of use. **What do you dislike about Amazon Redshift?** While Redshift offers cost-effective options, the charges for data storage, query processing, and additional features can accumulate quickly, especially if you're dealing with large volumes of data or complex queries. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift allows organizations to store and analyze vast amounts of data in a scalable and cost-effective manner. It can easily handle terabytes to petabytes of data, accommodating the growing volume of data generated by businesses. ### 29. Integrated with other AWS services and cost effective **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Small-Business (50 or fewer emp.) **Reviewed Date:** February 20, 2024 **What do you like best about Amazon Redshift?** Pay as per usage Ese of use Nice UI has many features associated with AWS **What do you dislike about Amazon Redshift?** No free tech support Versioning is not free **What problems is Amazon Redshift solving and how is that benefiting you?** Cost per cluster. Hence can buy how much space is required for projects and add on if required more It solves the datawarehouse problems ### 30. The outstanding data warehouse service - Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Raghavendra L. | Cloud Enginner, Mid-Market (51-1000 emp.) **Reviewed Date:** August 07, 2023 **What do you like best about Amazon Redshift?** The most helpful part of Amazon Redshift is that it allows large quantity of data warehourse service in cloud. It offers tools that helps in administrating a database and hence is termed as Massively Prallel Processing Db. **What do you dislike about Amazon Redshift?** The least hepful part fo Amazon Redshift is that the datatypes such as JSON and XML are not fully supported as working with the data with unsupported format can lead to various tedious tasks. **What problems is Amazon Redshift solving and how is that benefiting you?** Most of proffessionals wants to retrieve adequate data and in Amazon Redshift it is easy to querry the data. The proffessionals who know Postgre SQL can easily apply simillar terminology to queery data in redshift. ### 31. "Optimizing Data Insights:Amazon Redshift" **Rating:** 5.0/5.0 stars **Reviewed by:** anoop s. | Small-Business (50 or fewer emp.) **Reviewed Date:** September 23, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift provide robust security features to protect to data including authentication and access control. Ease of uses and find user friendly with SQL like query quality and Ease of Implementation. Amazon Redshift has high-performance analytics and can process complex queries quickly. **What do you dislike about Amazon Redshift?** Not necessarily disadvantages of Amazon Redshift but rather aspects that organisation should be aware of when evaluating and using the services. And complex for new users **What problems is Amazon Redshift solving and how is that benefiting you?** It provides a familiar SQL interface making it accessible to data analysts and SQL developers. This is easy of uses to allow SQL in the organizations. Amazon Redshift optimize for High performance analyst. It is use columnar storage and parallel query execution to deliver fast query results. ### 32. Great for Analytical Workload **Rating:** 5.0/5.0 stars **Reviewed by:** Akhil G. | Mid-Market (51-1000 emp.) **Reviewed Date:** January 31, 2024 **What do you like best about Amazon Redshift?** - Fully-managed, petabyte scale data warehouse service. - Integration with other AWS Services. - Short Query Acceleration (SQA) **What do you dislike about Amazon Redshift?** - Data write with EMR is slow. - Can't use for the Unstructured data **What problems is Amazon Redshift solving and how is that benefiting you?** Help to handle the Analytical Workloads ### 33. A great platfrom to crunch your Data **Rating:** 4.5/5.0 stars **Reviewed by:** Shubhi S. | ETL Developer - Talend, Mid-Market (51-1000 emp.) **Reviewed Date:** March 09, 2022 **What do you like best about Amazon Redshift?** The overall features, support, and availability are great. Amazing way to run all kinds of DB on the platform. Easy to for hardware processing and patching activities. **What do you dislike about Amazon Redshift?** More documentation and support that will be helpful **Recommendations to others considering Amazon Redshift:** If you have a huge data this is the platform for your to build your Data warehouse and most importantly you can save a lot of money. **What problems is Amazon Redshift solving and how is that benefiting you?** Speed query upgrades, are a great way to scale up with very few implications. Dealing with a lot of Data in our day-to-day operations so AWS plays a major role in simplifying the data. ### 34. Great for data warehousing! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** March 05, 2024 **What do you like best about Amazon Redshift?** Speed, price, and the ease of use. The serverless option make it so much faster and easier to manage the system itself. **What do you dislike about Amazon Redshift?** Dealing with relationships more like a traditional RDS database could be helpful. **What problems is Amazon Redshift solving and how is that benefiting you?** Data warehousing is made so much easier. Moving data from S3 into Redshift is very easy thanks to the COPY functionality. ### 35. Amazon Redshift Review A tool by AWS for Data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** December 31, 2023 **What do you like best about Amazon Redshift?** Most helpful and upside using Amazon Redshift is that it's security and E2E encryption. And its support for multi query which results in high speed performance and best features Ibhave used for Redshift are data warehousing techniques and auto scaling and auto backup. And aws data pipline. For loading data files. **What do you dislike about Amazon Redshift?** Least helping for there is nothing as of now. Integration and deployment need documentation **What problems is Amazon Redshift solving and how is that benefiting you?** Used for client data integration and big data analytics. Storage limit has benifited us in our project. Dynamic query. ### 36. A Powerful Data Warehousing Solution! **Rating:** 4.0/5.0 stars **Reviewed by:** Neelesh T. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 10, 2023 **What do you like best about Amazon Redshift?** Its web-based console allows us to quickly provision new clusters, monitor usage, and scale resources up or down as needed. Additionally, it integrates seamlessly with other AWS services, so overall it is a powerful data warehousing solution that is definitely worth considering. **What do you dislike about Amazon Redshift?** One potential downside is its cost, which can add up quickly for large amounts of data. Additionally, the learning curve for using Amazon Redshift can be steep for users unfamiliar with cloud-based data warehousing solutions. Finally, the lack of built-in functionality for specific data types can make working with certain types of data complex. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift solved various data warehousing problems by handling large-scale data analytics and processing petabytes of data in seconds. Also, it seamlessly scales up or down based on business needs, eliminating capacity constraints and simplifies complexity by integrating with various business intelligence tools, being easy to set up and use. Plus, it’s cost-effective, allowing payment only for resources used. ### 37. Database warehousing tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** December 31, 2023 **What do you like best about Amazon Redshift?** Building data lake using Redshift is excellent. It's columnar storage feature is the one the best feature. Querying large datas with efficient parallel processing and dara compression was not thats efficient. Easy of data loading to Redshift. **What do you dislike about Amazon Redshift?** Backup ing data to ES3 could be better or more efficient. Auto backup is great. **What problems is Amazon Redshift solving and how is that benefiting you?** Deployment of cloud on premises. And data modeling for relation databases. Integration of data leaks with other AWS services. Helping in data warehousing. ### 38. One of the best data warehouse there is. **Rating:** 5.0/5.0 stars **Reviewed by:** Ayush S. | Mid-Market (51-1000 emp.) **Reviewed Date:** May 18, 2023 **What do you like best about Amazon Redshift?** * Cheapest Data Warehouse in the market. * Highly Scalable * With a high-value brand name backing it, people trust it. * Integration with a ton of different applications is probably it's most direct feature. **What do you dislike about Amazon Redshift?** * The pain to COMMIT all the DDLs and DMLs manually (or tick the box) when it should be by default. * Missing the ability to run ACID compliant queries directly on Data Lake. * Missing Delta Lake Capabilities. **What problems is Amazon Redshift solving and how is that benefiting you?** Not only is it cheap but is also very fast in running big data workloads. It's ability to integrate with various in house AWS apps as well as other Web/Cloud based applications to integrate it's data and perform analytics on it is a real boon. I recently saw Redshift's connection with Facebook Audience Network using HEVO data and was really amazed on how we can now analyze our facebook ad data with so much ease. ### 39. Aws Databases **Rating:** 5.0/5.0 stars **Reviewed by:** Sagar Ganesh R. | Technology Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2023 **What do you like best about Amazon Redshift?** It has all types of enhancements, integration, metric calculations and lot more features such as lambda, s3, putty, memory instances, putty features which helps us to thoroughly enjoy the aws features and queries the aws table as fast as possible **What do you dislike about Amazon Redshift?** There is nothing we can dislike about aws. It's the best. And the support team here is amazing. Whenever we face a glitch they are help to us 24/7. What else is there to complain. Negative. **What problems is Amazon Redshift solving and how is that benefiting you?** The transformation of data with millions of records are very fast and whenever we are dealing with big data, performance is a factor where we need to bother, but using aws services, there is nothing to worry about. Everything is smooth here. ### 40. Senior Data Engineer **Rating:** 5.0/5.0 stars **Reviewed by:** Karunakar M. | Lead Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 21, 2024 **What do you like best about Amazon Redshift?** Building Dataware house in cloud from legacy **What do you dislike about Amazon Redshift?** No downside yet as it is going well as expected **What problems is Amazon Redshift solving and how is that benefiting you?** Bringing Teradata warehouse into cloud ### 41. Scalable and cost-effective cloud data warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Ankur R. | Business Technology Solutions Associate, Mid-Market (51-1000 emp.) **Reviewed Date:** May 05, 2023 **What do you like best about Amazon Redshift?** Redshift enables users to effortlessly scale their data warehousing infrastructure up or down in accordance with their demands without worrying about the purchase or maintenance of hardware. Redshift's pay-as-you-go pricing structure also enables users to only pay for the resources they actually use, which can save consumers a lot of money in comparison to traditional on-premises data warehousing solutions. **What do you dislike about Amazon Redshift?** Large data sets might take a while to load into Redshift, especially if they need to be converted or go through pre-processing. Redshift has fewer partitioning options than some other data warehousing platforms, which can make it harder to optimise performance for certain use cases. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift is scalable and cost-effective. Without having to worry about purchasing or maintaining hardware, I can simply scale my data warehousing architecture up or down to meet client demands with Redshift. I can manage enormous data sets and workload peaks because to its scalability without having to pay a high upfront fee. ### 42. Revolutionizing Data Warehousing: A Closer Look at Amazon Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Siddharth S. | Cloud Engineer Trainee , Enterprise (> 1000 emp.) **Reviewed Date:** May 18, 2023 **What do you like best about Amazon Redshift?** I appreciate the query optimization capabilities of Amazon Redshift, as it intelligently selects the most efficient execution plans, resulting in faster query performance and enabling swift analysis of large datasets. **What do you dislike about Amazon Redshift?** I dislike about Amazon Redshift is the requirement for meticulous planning and monitoring of their usage, as it is essential to consider factors such as data size, cluster size, and data transfer frequency to ensure optimal cost efficiency and minimise the risk of unexpected expenses **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift efficiently handles and analyzes massive datasets, from terabytes to petabytes in size, through its columnar storage, parallel processing, and data compression techniques, resulting in optimized query performance. ### 43. Redshift is simple, for good and bad **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** October 18, 2023 **What do you like best about Amazon Redshift?** Redshift has proven to be a very valuable database for us, keeping us satisfied for years. However, recently we have decided to shift to Databricks in order to get access to a better UI and more optionality around how we use our data. **What do you dislike about Amazon Redshift?** Redshift doesnt offer as many tools as other data warehouses, such as built in visualization or auto-ML tools. It is quite basic, but it still comes at a high price. **What problems is Amazon Redshift solving and how is that benefiting you?** Redshift is giving us a data warehouse to store our customer and conversion data. This is important for our analysis, but beyond storage Redshift offers us little other tangible uses. ### 44. I loved it's speed it uses SQL to analyze structured and semi-structured data across data warehouses **Rating:** 4.0/5.0 stars **Reviewed by:** Sakharam R. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 25, 2023 **What do you like best about Amazon Redshift?** It's data processing speed just in second we will get our output. 3times faster than other could platform. It helps me as developer to optimise performance of process **What do you dislike about Amazon Redshift?** Some time it's lack during high workload but overall performance is too good highly recommend **What problems is Amazon Redshift solving and how is that benefiting you?** To store high volume of data. And also data is available at any time with high computation power. ### 45. Amazon Redshift is one of the best data warehouse solution **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** June 29, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift is incredibly fast; we run a multinode cluster and can run aggregations on hundreds of millions of rows in a few seconds. Amazon redshift is low-cost compared to competitors. Amazon Redshift is horizontally scalable; you can add more nodes to handle additional workloads. It is easy to manage as Redshift is based on SQL, and the amazon redshift query engine has the same interface as PostgreSQL. **What do you dislike about Amazon Redshift?** We are using Amazon Redshift as a data warehouse solution to handle petabytes of data and did not see many issues so far. **What problems is Amazon Redshift solving and how is that benefiting you?** We use Amazon Redshift as a data warehouse solution for data analytics cases, which works perfectly. Amazon Redshift is incredibly fast; we run a multinode cluster and can run aggregations on hundreds of millions of rows in a few seconds. Amazon Redshift is low-cost compared to competitors. Amazon Redshift is horizontally scalable; you can add more nodes to handle additional workloads. It is easy to manage as Redshift is based on SQL, and the amazon redshift query engine has the same interface as PostgreSQL. ### 46. Review for Amazon Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** PRIYANSHU P. | Test engineer , Enterprise (> 1000 emp.) **Reviewed Date:** May 28, 2023 **What do you like best about Amazon Redshift?** Amazon Redshift is one of best Data warehousing tool offer by AWS and it give real time data analytics and allows quickly run complex queries on large amount of data, that's why it provides the real- time insights helps to make great decision. **What do you dislike about Amazon Redshift?** Nothing i dislike about the AWS Redshift. **What problems is Amazon Redshift solving and how is that benefiting you?** For me the Amazon Redshift is solving a problem of data analytics because working on a large data and it efficient works on data providing me a real time insights through which i able make a good decision. ### 47. Scalable and Cost-effective Data Warehousing with Amazon Redshift **Rating:** 4.5/5.0 stars **Reviewed by:** Hafiz A. | Tutor, Mid-Market (51-1000 emp.) **Reviewed Date:** April 04, 2023 **What do you like best about Amazon Redshift?** One of the most beneficial aspects of Amazon Redshift is its scalability, which allows users to store and analyze large amounts of data quickly. It also offers a cost-effective solution compared to traditional data warehousing options. Here are some upsides of using Amazon Redshift: 1. Scalability: Amazon Redshift is designed to handle massive amounts of data and can scale up or down quickly to meet changing demands. 2. Affordability: With Amazon Redshift, users only pay for what they use, making it a cost-effective option for organizations of all sizes. 3. Integration with other AWS services: Amazon Redshift integrates seamlessly with other AWS services, making it easy to move data between services for analysis. 4. Security: Amazon Redshift offers a range of security features, such as encryption at rest and in transit and access control mechanisms to ensure that data is protected. 5. Ease of use: Amazon Redshift is user-friendly and easy to set up and use, even for users with limited technical expertise. 6. Customizability: Amazon Redshift allows users to customize their data warehousing environment to meet their specific needs, including the ability to create custom SQL functions and user-defined types. Overall, Amazon Redshift is a versatile and powerful data warehousing solution that offers a range of benefits to users, including scalability, affordability, ease of use, and security. **What do you dislike about Amazon Redshift?** While Amazon Redshift has many benefits, there are also some potential downsides to using the service. Here are a few examples: 1. Limited SQL support: Amazon Redshift has some limitations regarding SQL support, such as lacking support for advanced SQL features. This may be a drawback for users with complex data warehousing needs. 2. Complex setup: While Amazon Redshift is generally user-friendly, setting up and configuring the service can be difficult and time-consuming, especially for users with limited technical expertise. 3. Query performance: In some cases, query performance can be slower than other data warehousing solutions, especially when dealing with complex queries or large datasets. 4. Data ingestion: While Amazon Redshift integrates well with other AWS services, ingesting data from external sources can be complex and time-consuming. 5. Cost: While Amazon Redshift can be cost-effective compared to traditional data warehousing options, it can still be expensive for users with large datasets or high query volumes. Overall, while Amazon Redshift is a powerful and flexible data warehousing solution, users should carefully consider their needs and the potential downsides before choosing the service. It may not be the best fit for all users, especially those with highly complex data warehousing requirements. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift helps organizations solve various problems related to data warehousing and analysis. Some examples include: 1. Scaling data storage and analysis: Amazon Redshift can handle massive amounts of data, making it a good solution for organizations that need to store and analyze large datasets. 2. Improving data analysis and insights: With Amazon Redshift, users can quickly query and analyze data, enabling them to identify trends, patterns, and insights that can help drive business decisions. 3. Reducing costs: Amazon Redshift's pricing model allows organizations to only pay for what they use, making it a more cost-effective solution than traditional data warehousing options. 4. Enhancing data security: Amazon Redshift offers a range of security features, such as encryption at rest and in transit, and access control mechanisms, helping to keep data safe from unauthorized access. 5. Integrating with other AWS services: Amazon Redshift seamlessly integrates with other AWS services, making it easy to move data between services and perform analysis across different data sources. Overall, Amazon Redshift can help organizations solve various problems related to data storage, analysis, and insights, making it a powerful tool for businesses of all sizes. ### 48. Amazon Redshift: A Cloud Data Warehouse Solution Review **Rating:** 3.5/5.0 stars **Reviewed by:** Siva S. | DevOps Technical Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** April 04, 2023 **What do you like best about Amazon Redshift?** Fast, scalable and secure AWS data warehouse **What do you dislike about Amazon Redshift?** The learning curve and possible bottle necks **What problems is Amazon Redshift solving and how is that benefiting you?** AWS Redshift is designed to address various challenges related to data storage, analysis, and reporting. Some of the problems it can solve include: Large-scale data analysis: Redshift's columnar storage, data compression, and massively parallel processing capabilities make it ideal for processing and analyzing vast amounts of data quickly and efficiently. Scalability: With its easy-to-scale architecture, Redshift allows organizations to accommodate growing data volumes without compromising performance. Users can add or remove nodes as needed to meet their storage and computing requirements. Data consolidation and warehousing: Redshift enables businesses to consolidate data from disparate sources into a single, unified data warehouse, making it easier to analyze and derive insights from the collected data. Real-time analytics: By integrating with streaming data services like Amazon Kinesis, Redshift allows organizations to perform real-time analytics on continuously flowing data, enabling faster decision-making and more timely insights. Integration with existing tools and services: Redshift seamlessly connects with popular business intelligence tools (e.g., Tableau, Looker, Power BI) and various AWS services, making it easier for organizations to build comprehensive data analysis solutions. Simplified data management: As a fully managed service, Redshift handles tasks like backups, patching, and hardware provisioning, allowing users to focus on analyzing their data rather than managing infrastructure. Cost optimization: Redshift's pay-as-you-go pricing model ensures that organizations only pay for the resources they use, making it a cost-effective solution for data warehousing and analytics. By addressing these challenges, AWS Redshift empowers organizations to efficiently store, process, and analyze their data, ultimately enabling them to make better-informed decisions and drive growth. ### 49. Review for Amazon Redshift **Rating:** 4.0/5.0 stars **Reviewed by:** Ankit S. | Associate Product Manager, Enterprise (> 1000 emp.) **Reviewed Date:** May 21, 2023 **What do you like best about Amazon Redshift?** 1. Easy to implement or set up on-premise 2. AWS console is very quick in querying tables 3. Easy to upload data 4. Give user to deep dive into insights as it is compatible with many visualization tools **What do you dislike about Amazon Redshift?** 1. Training documentation is not so detailed 2. Learning requires at least a month of time 3. Price is a bit high as compared to other providers 4. Debugging is a quite annoying **What problems is Amazon Redshift solving and how is that benefiting you?** 1. It's a secured cloud-based data warehousing solution and can be accessed from each and every office of my company across globe 2. It helped in data importing and ETL of all kinds of data and data files 3. It helped in querying data in real-time ### 50. Powerful and Reliable Data Warehousing Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Ramon S. | Anaylst, Enterprise (> 1000 emp.) **Reviewed Date:** March 01, 2023 **What do you like best about Amazon Redshift?** I have been using Amazon Redshift for a while now, and I have to say that I am very impressed with its performance and reliability. The speed and scalability of this cloud-based data warehousing solution are unmatched, and it has allowed me to process and analyze large amounts of data quickly and efficiently. There are no problems at all if you are transitioning from other solutions in terms of T-SQL. **What do you dislike about Amazon Redshift?** I haven't found any dislikes regarding Amazon Redshift, but a few things could be more manageable depending on the client you use for querying the database. I've found some issues with schemas updates and synchronization. **What problems is Amazon Redshift solving and how is that benefiting you?** Amazon Redshift solves several data warehousing problems; the main ones that benefit me are performance and speed. Its high-performance computing capabilities allow me to analyze large datasets quickly and efficiently, which helps me make better business decisions on time. Besides that, I also find Integration and Scalability two of the most significant assets of this tool. ## 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?section=pricing&secure%5Bexpires_at%5D=2026-06-11+21%3A43%3A29+-0500&secure%5Bsession_id%5D=85724ff3-a989-481c-908b-d18ff9ab345c&secure%5Btoken%5D=43ca6f8a0659387db36da8406a07bf8b75a69b75fb7c494d6d30012fb2afac2e&format=llm_user) ## Amazon Redshift Integrations - [Amazon AppFlow](https://www.g2.com/products/amazon-appflow/reviews) - [Informatica Cloud Data Integration](https://www.g2.com/products/informatica-cloud-data-integration/reviews) - [Informatica Data Engineering](https://www.g2.com/products/informatica-data-engineering/reviews) - [Liquibase](https://www.g2.com/products/liquibase/reviews) - [Metabase](https://www.g2.com/products/metabase/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) ## Amazon Redshift Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Storage** - Data Model - Data Types **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Availability** - Auto Sharding - Auto Recovery - Data Replication **Deployment** - On-Premise - Cloud **Performance** - Integrated Cache **Performance ** - Scalability **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Security** - Data Governance - Data Security **Support** - Multi-Model - Operating Systems **Generative AI** - AI Text Generation - AI Text Summarization ## Top Amazon Redshift Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,148 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (705 reviews) - [OpenText Vertica](https://www.g2.com/products/opentext-vertica/reviews) - 4.3/5.0 (195 reviews)