Name: Amazon Redshift
Rating: 4.4 (551 reviews)

Overview

Product Information on Amazon Redshift

Updated 13th October 2025

What is Amazon Redshift?

Amazon Redshift is a software that offers a fully managed data warehouse solution designed to handle large-scale data storage and query workloads. It enables users to analyze data across their data warehouse and data lake using standard SQL and integrates with a wide variety of business intelligence tools. The software supports high-performance querying and employs columnar storage, data compression, and parallel processing to increase efficiency. It addresses business challenges related to scalable data management and analytics, facilitating tasks such as reporting, dashboarding, and predictive analytics. Amazon Redshift supports both structured and semi-structured data, allowing organizations to gain insights from diverse data sources while maintaining data security and reliability through comprehensive features for monitoring, encryption, and access control.

Overall experience with Amazon Redshift

Data Analyst

1B - 3B USD, Healthcare and Biotech

FAVORABLE

“Real-Time Data Delivery Enhanced by Amazon Redshift with Some Feature Restrictions”

5.0

Apr 22, 2026

The experience with Amazon has been great as it helps us with our daily tasks with faster performance with the capabilities it has. The features in Amazon Redshift help day-to-day users make life easy. As it is an Amazon product, it is easy to incorporate with other Amazon services for further use. For example: Using Amazon Redshift to query and get results from complex data, which can later pull the data into Amazon QuickSight SPICE for data visualizations and dashboard building which can help to deliver to end users the data they want to see with real-time refresh.

Engineer

10B - 30B USD, Travel and Hospitality

CRITICAL

“RBAC Limitations Impact Effectiveness of Late Binding and Consumption Views”

3.0

Dec 1, 2025

query vs loading creates issues and requires consumption views which do not work nicely with RBAC

About Company

Company Description

Amazon Web Services (AWS), established in 2006, is focused on providing essential infrastructure services to businesses globally in the form of cloud computing. The key advantage offered through cloud computing, particularly via AWS, is its capacity to shift fixed infrastructure expenses into flexible costs. Businesses have been able to forgo extensive planning and procurement of servers and other Information Technology (IT) resources, owing to AWS. AWS seeks to provide businesses with prompt and cost-effective access to resources using Amazon's expertise and economies of scale, as and when their business requires. Currently, AWS offers a robust, scalable, economic infrastructure platform on the cloud powering an extensive array of businesses worldwide. It operates across numerous industries with data center locations in various parts of the globe including U.S., Europe, Singapore, and Japan.

Company Details

Company type

Public

Year Founded

2006

Head office location

Seattle, United States

Number of employees

10001+

Website

http://aws.amazon.com

Do You Manage Peer Insights at Amazon Web Services (AWS)?

Access Vendor Portal to update and manage your profile.

Key Insights

A Snapshot of What Matters - Based on Validated User Reviews

User Sentiment About Amazon Redshift

Reviewer Insights for: Amazon Redshift

Deciding Factors: Amazon Redshift Vs. Market Average

Performance of Amazon Redshift Across Market Features

Amazon Redshift Likes & Dislikes

The things I like most about Amazon Redshift are: 1. It handles different types of databases i.e. structured and semi-structured. 2. As the data refreshes for the real-time , it is convenient for the users to view the real-time data. 3. Amazon Redshift helps run complex queries faster by operating on huge volumes of data, which helps developers get results faster and in a more efficient way. 4. The 'Result Caching' feature helps to get the results when query is executed in faster time. 5. The 'Query Optimizer' helps to make the input query optimized for efficient performance. 6. 'Data Compression' helps to compress the query while executed to take up less memory, so that execution is faster. 7. Redshift is way easier to integrate with applications and create views for datasets.

ease of connection

1. It is a part of the AWS ecosystem. So in order to involve other AWS products, you don't have to go through APIs, oAuth credentials, or anything of the sort. The integration is much more streamlined. For example, depending on how your databases are setup, you can reference data outputs from S3 or Lambda logs easily. 2. The cost is much lower when compared to competitors and the tooling Redshift provides allows you to predict cost much easier than its competitors. 3. Since it's an analytical database, using Redshift as the source for dashboards allows for faster loading of data and running of queries. Since we do the majority of our transformations in dbt, a lot of our queries are synthesized into tables which means that we use Redshift for semantic layer transformations which is what most users are frustrated with when they refer to long loading times for dashboards. Using Redshift makes this not as much of an issue.

The dislikes for Amazon Redshift are: 1. As it uses PostgreSQL, it doesn't support all features of PostgreSQL. 2. Amazon Redshift has a maximum cluster size of 128 nodes, which can restrict the user from using huge data and also for data processing. 3. Amazon Redshift supports only a limited number of datatypes. 4. As it is a Tightly Coupled Architecture, that can affect the processing of data, which can shoot up the fast performance ability. 5. Amazon Redshift can have a maximum of 20 thousand tables which can lead back for any users working on huge complex data to use it. 6. A few transformations for files like JSON cannot be done in Amazon Redshift. 7. When we try to filter down for data in a column, the filtered data doesn't show up which might lead to confusion for users using the filters.

rbac across late binding views adding sort keys to large existing tables recreating large tables to update dist keys

1. Creating and updating incremental tables can be very difficult due to Redshift's table lockout mechanism. 2. Navigating the UI (in terms of schemas, columns, CRUD functions) can feel outdated and frustrating as it is not intuitive. 3. Permissions and access can be a bit unwieldy as it's not intuitive.

Top Amazon Redshift Alternatives

Peer Discussions

Amazon Redshift Reviews and Ratings

Recommended Gartner Insights

1B-10B USD

Healthcare and Biotech

Review Source

Real-Time Data Delivery Enhanced by Amazon Redshift with Some Feature Restrictions

Data And Analytics Manager

50M-1B USD

Software

Efficient Dashboard Performance With Redshift Faces Obstacles in Usability and Permissions

4.0

Feb 9, 2026

Although Redshift is a bit archaic and lagging in terms of configuration and technology when compared to its competitors, Redshift has always been reliable and performant.

Associate Director Of Special Projects

Gov't/PS/Ed

Education

Amazon Redshift Streamlines Querying with Occasional Performance Challenges

Mar 20, 2026

As a user, Redshift has been effective as data warehouse where we can easily access and pull out whatever we need in a usable form.

Cloud Devops Engineer

Travel and Hospitality

AWS Redshift Enables Scalable Analytics With Notable Features and Some SQL Challenges

Mar 31, 2026

AWS has a large breadth of services and AWS Redshift is one of the highlights. Redshift is built on a massively parallel processing architecture which allows the storage of massive amounts of data that can be easily used to run complex analytical queries against. It is a valuable service for any enterprise data storage plan.

DATA ANALYST

Manufacturing

Redshift Facilitates Scalable Analytics but SQL Similarities Cause Query Challenges

Redshift has been a great tool for the storage and serving of our Google Analytics data. It has allowed us to capture a lot of information as we see a lot of traffic and then send it down stream for further processing.