Search
Close this search box.
Customer Satisfaction
2.7/10
2.7
User Experience
6.0/10
6.0
Technical Foundation
5.0/10
5.0
Business Value
1.9/10
1.9

Amazon Redshift

What is Amazon Redshift?

Cloud-based data warehouse based on S3 with query engine that enables queries on linked data from Redshift and Data Lake (S3).

Data Management & Storage
● Databases & Access Engines
– Data Intelligence, Data Catalogs and Marketplaces
– Data Operations
– Data Pipelining and Data Quality

= covered

About Amazon Redshift

Self-description of the vendor

No vendor self-description available
References
No data available
Partners
No data available

Amazon Redshift BARC Review & Rating

Provider and product description

Amazon, founded in 1994 in Washington, initially started as an online bookstore but has since transformed into a global technology company. Headquartered in Seattle, WA, Amazon is widely known for its e-commerce platform, Amazon.com, and its leadership in cloud computing through Amazon Web Services (AWS) founded in 2006. AWS holds 33 percent of the cloud computing market and works with over 90 percent of Fortune 100 companies.

Amazon Web Services (AWS) provides over 200 services that span data storage, computing, machine learning (ML) and artificial intelligence (AI). The AWS Marketplace hosts more than 4,700 data products and over 4,000 ML products, connecting third-party sellers with buyers. AWS serves diverse sectors, including government, enterprises, educational institutions and individuals. AWS operates in 108 Availability Zones across 34 global regions, along with many edge locations and local zones.

Amazon Redshift is a key service in AWS’s data and analytics offerings. It is a cloud-based relational data warehouse designed for large-scale data processing. Redshift integrates seamlessly with other AWS services, such as Amazon Data Lake and Amazon SageMaker, enabling users to leverage advanced analytics and machine learning within the same ecosystem. With its columnar storage and massively parallel processing (MPP) architecture, Redshift provides optimized query performance for analytics and reporting.

Redshift’s data management is built on efficient workflows. Data can be loaded from Amazon S3 into Redshift, processed and then unloaded back into S3 for further analysis. Redshift Spectrum allows users to query data stored in S3 without moving it into Redshift, saving time and storage.

Recent enhancements to Amazon Redshift include:
• Support for zero-ETL integration: Customers can leverage new flexibility to control the frequency of data replication. The refresh interval provides new granular control.
• Data sharing for data lakes tables: Enables customers to securely share data at various levels, including tables and views via Redshift and Lake Formation.
• Amazon Sagemaker JumpStart for Redshift ML: Enables customers to create, train and deploy machine learning models on their Redshift data using SQL commands.

Strengths and challenges of Amazon Redshift

BARC’s viewpoint on the product’s strengths and challenges.

Strengths
  • Redshift is top ranked for Adaptability in the Cloud Data Platforms peer group
  • Overall, Redshift scored well in the User Experience KPI for its peer group
  • A pre-existing relationship with AWS is an important driver for organizations purchasing the solution
Challenges
  • Redshift customers encounter significant challenges when attempting to scale the environment
  • Redshift customers experience high complexity in the administration and operation of the Redshift environment at twice the average for all products in this segment
  • The Redshift solution suffers from a lack of business user interest at a much higher rate than other cloud data platforms
Need more help finding the right software?

Find out how our expertise can help you.

Amazon Redshift User Reviews & Experiences

The information contained in this section is based on user feedback and actual experience with Amazon Redshift.

The information and figures are largely drawn from BARC’s The BI & Analytics Survey, The Planning Survey, The Financial Consolidation Survey and The Data Management Survey. You can find out more about these surveys by clicking on the relevant links.

Who uses Amazon Redshift in a data management context and how

Why users buy Amazon Redshift and what problems they have using it

Premium content. Unlock with BARC+.
For just €79 per month (€948 per year) you can access all the paid content on www.barc.com.
Your benefits:

Full user reviews and KPI results for Amazon Redshift

All key figures for Amazon Redshift at a glance.

Premium content. Unlock with BARC+.
For just €79 per month (€948 per year) you can access all the paid content on www.barc.com.
Your benefits:

Individual user reviews for Amazon Redshift

Role
Consultant
Number of employees
More than 2.500
Industry
Consulting
Source
BARC Panel, The Data Management Survey 25, 02/2024
What do you like best?

Close to PostgreSQL, as it's a fork.

What do you like least/what could be improved?

Performance is constantly a challenge.

What key advice would you give to other companies looking to introduce/use the product?

Move to Snowflake.

How would you sum up your experience?

Rather poor - it requires a shift on how they do things.

Role
Project manager for BI/analytics from IT
Number of employees
More than 2.500
Industry
Transportation and logistics
Source
BARC Panel, The Data Management Survey 25, 02/2024
What do you like best?

It helps get the data to where it needs to be faster.

What do you like least/what could be improved?

Lack of expert knowledge within my org.

What key advice would you give to other companies looking to introduce/use the product?

Get people trained or bring in an expert.

How would you sum up your experience?

Positive.

Survey Information
Number of reviews for Amazon Redshift
20
Reviewed versions
56 percent version 1.0.46, 44 percent version 1.0.47
Peer groups in the survey
Cloud Data Platforms, Data Platforms
Check out the world´s most comprehensive guide to the Power BI ecosystem.