Name: Amazon Redshift
Rating: 4.4 (550 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 And Analytics Manager

50M - 250M USD, Software

FAVORABLE

“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.

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

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.

ease of connection

Three areas that I have appreciated in Amazon Redshift are: 1. It is easy to query data directly, saving considerable time and effort in having to search and clean up desired datasets. 2. There has been easy integration of Redshift into our business intelligence tools, streamlining the process of creating visualizations and other 3. The data warehouse updates quickly based on the systems it is linked to, thereby making it easy to fulfill data requests in a shorter timeframe.

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.

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

Some areas of improvement I have noticed in Amazon Redshift have been: 1. For some reason, attempting to process individual statements can be slower than processing statements for larger batches of data. 2. Since there is no enforcement of unique keys, there is a risk of duplicate data accidentally being inserted and therefore requiring extra cleanup time. 3. Concurrent logins into Redshift can sometimes cause queries to get backed up, slowing down the process.

Top Amazon Redshift Alternatives

Peer Discussions

Amazon Redshift Reviews and Ratings

Recommended Gartner Insights

50M-1B USD

Software

Review Source

Efficient Dashboard Performance With Redshift Faces Obstacles in Usability and Permissions

Associate Director Of Special Projects

Gov't/PS/Ed

Education

Amazon Redshift Streamlines Querying with Occasional Performance Challenges

5.0

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

1B-10B USD

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.

PRODUCT MANAGER

<50M USD

IT Services

Amazon Redshift Offers Reliable Analytics Performance Yet Faces Cost Management Challenges

Oct 24, 2025

Amazon Redshift delivers strong performance and reliability for large scale analytics. It integrates smoothly with other AWS tools like S3 and QuickSight, making data workflow efficient. Scaling is efortless, and performance tuning are powerful. The only minor challange is managing costs for unpredictable workloads.