Amazon Redshift Reviews & Product Details

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.

Seller

Amazon Web Services (AWS)

Discussions

Amazon Redshift Community

Product Description

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.

Overview by

John Miranda (Digital Marketing Specialist at Amazon Web Services)

Pricing

Pricing provided by Amazon Redshift.

RA3.4xlarge

$1.22 - $3.26

Per hour

RA3.16xlarge

$8.61 - $13.04

Per hour

View More Pricing Information

Top-Rated Alternatives

Google Cloud BigQuery

View All Alternatives

Amazon Redshift Integrations

(2)

Integration information sourced from real user reviews.

Amazon Redshift Media

Amazon Redshift Demo - Amazon Redshift Setup

Choose the best node type for your workload.

Amazon Redshift Demo - Amazon Redshift Console

Home view in the Amazon Redshift console.

Amazon Redshift Demo - Amazon Redshift Advisor

The Amazon Redshift Advisor makes recommendations to optimize your data warehouse.

Amazon Redshift Demo - Amazon Redshift Query Monitoring

Monitor queries in the Amazon Redshift console.

Amazon Redshift Demo - Amazon Redshift Query Plan

View query plans in the Amazon Redshift console.

G2 reviews are authentic and verified.

Here's how.

PRIYANSHU P.

Test engineer

Enterprise (> 1000 emp.)

5/28/2023

"Review for Amazon Redshift"

5/5

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. Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

Nothing i dislike about the AWS Redshift. Review collected by and hosted on G2.com.

Hafiz A.

Tutor

Mid-Market (51-1000 emp.)

4/4/2023

"Scalable and Cost-effective Data Warehousing with Amazon Redshift"

4.5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Siva S.

DevOps Technical Lead

Mid-Market (51-1000 emp.)

4/4/2023

"Amazon Redshift: A Cloud Data Warehouse Solution Review"

3.5/5

What do you like best about Amazon Redshift?

Fast, scalable and secure AWS data warehouse Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

The learning curve and possible bottle necks Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Ankit S.

Associate Product Manager

Enterprise (> 1000 emp.)

5/21/2023

"Review for Amazon Redshift"

4/5

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

Ramon S.

Anaylst

Enterprise (> 1000 emp.)

3/1/2023

"Powerful and Reliable Data Warehousing Solution"

5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

himanshu j.

Lead - Analytics

Small-Business (50 or fewer emp.)

7/4/2023

"Amazon Redshift: The SOTA Data Powerhouse"

5/5

What do you like best about Amazon Redshift?

Best-in-class data warehousing, integrations, support and maintenance services provided by AWS over Redshift with state-of-the-art data warehousing pipeline building and concurrency scaling features Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

The batch processing disallows real-time data ingestion and analysis, impacting reporting and data consumption at other ends. Also, sometimes challenges occur when loading/unloading massive data at once or with complex queries Review collected by and hosted on G2.com.

Rachit M.

Entity Non Officer

Enterprise (> 1000 emp.)

5/30/2023

"AWS Redshift Review"

4.5/5

What do you like best about Amazon Redshift?

AWS Redshift is a plug-and-play-like service provided by AWS, and it helps us to integrate load and process data within minutes. Resources are automatically provisioned and automatically scaled as per the demands Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

AWS Redshift is not available in all the AWS regions. The pricing is based on usage per second, making it a little costly. It does not have any free tier. It dimension the data poorly sometimes Review collected by and hosted on G2.com.

Aniket G.

Senior Data Engineer

Mid-Market (51-1000 emp.)

5/12/2023

"Best and easy to maintain when you have data in GBs, turn costly when data reaches in TBs"

4/5

What do you like best about Amazon Redshift?

1. A simple easy to start and easy to maintain data warehouse service by AWS.

2. Support in build optimisation and compression which result in faster query results and less memory required to store data.

3. Complete SQL support which makes data analyst easy to analyse the data. Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

1. Supports only structured data. At least it should support semi-structured data in easy ways.

2. When data increases we have to upgrade or scale out instances which becomes costlier. Review collected by and hosted on G2.com.

Rajan T.

Manager

Small-Business (50 or fewer emp.)

7/20/2022

"Big data integration platform"

4.5/5

What do you like best about Amazon Redshift?

It is a data warehouse where data reside on cloud and on top of it we can query the required data Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

Not 100% managed, multi cloud solution required, not a server less architecture Review collected by and hosted on G2.com.

Sweety W.

Senior Data Engineer

Mid-Market (51-1000 emp.)

6/2/2023

"Amazon redshift review"

3.5/5

What do you like best about Amazon Redshift?

Amazon redshift provides fast processing as we work on big data platforms loading of the data should be as fast as possible it is is good for querying as well as analytics Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

Not that I can think about as of now but it only supports parallel upload for specific data also most important it dies not eork as live app database it does not completely supports postgres Review collected by and hosted on G2.com.