Best Software for 2025 is now live!
Save to My Lists
Claimed
Claimed

Top Rated Amazon Redshift Alternatives

Amazon Redshift Reviews & Product Details - Page 4

Amazon Redshift Overview

What is 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 Details
Show LessShow More
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.


Seller Details
Year Founded
2006
HQ Location
Seattle, WA
Twitter
@awscloud
2,231,347 Twitter followers
LinkedIn® Page
www.linkedin.com
136,383 employees on LinkedIn®
Ownership
NASDAQ: AMZN
Total Revenue (USD mm)
$177,866
Description

By giving customers more of what they want - low prices, vast selection, and convenience - Amazon continues to grow and evolve as a world-class e-commerce platform.


John M.
JM
Overview Provided by:
Digital Marketing Specialist at Amazon Web Services

Recent Amazon Redshift Reviews

Vijay K.
VK
Vijay K.Enterprise (> 1000 emp.)
4.5 out of 5
"Amazon Redshift Review"
Amazon Redshift is one of the best data warehouse platforms provided by AWS. It uses SQL to analyze structured, semi-structured, and unstructure...
Happy M.
HM
Happy M.Enterprise (> 1000 emp.)
4.0 out of 5
"A complete data warehouse solution with scalability"
It provides easy to use and implement yet very powerful columns based data solution that helps in faster query performance. Also cross database ana...
matias d.
MD
matias d.Mid-Market (51-1000 emp.)
4.5 out of 5
"Great data warehouse solution"
It has a great pay as you go pricing which is useful for small companies and has amazing performance with little issues.
Security Badge
This seller hasn't added their security information yet. Let them know that you'd like them to add it.
0 people requested security information

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.
Answer a few questions to help the Amazon Redshift community
Have you used Amazon Redshift before?
Yes

Video Reviews

399 Amazon Redshift Reviews

4.3 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Popular Mentions
The next elements are radio elements and sort the displayed results by the item selected and will update the results displayed.
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
399 Amazon Redshift Reviews
4.3 out of 5
399 Amazon Redshift Reviews
4.3 out of 5

Amazon Redshift Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons

Overall Review Sentiment for Amazon RedshiftQuestion

Time to Implement
<1 day
>12 months
Return on Investment
<6 months
48+ months
Ease of Setup
0 (Difficult)
10 (Easy)
Log In
Want to see more insights from verified reviewers?
Log in to view review sentiment.
G2 reviews are authentic and verified.
Siddharth S.
SS
Cloud Engineer Trainee
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
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. Review collected by and hosted on G2.com.

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

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

Verified User in Hospital & Health Care
AH
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about AWS Analytics?

according to understanding past 2 year i worked on it AWS Analytics offers scalable and flexible solutions for data analysis. Its cost efficient pay as you go model, seamless integration with other AWS services, and managed nature simplify workflows. Real-time capabilities, security features, and machine learning integration enhance its value for various use cases Review collected by and hosted on G2.com.

What do you dislike about AWS Analytics?

according to me in Aws Analytics Challenges with the complexity in tool selection and setup, learning curves for new users, careful cost monitoring, potential service and limited customization. Review collected by and hosted on G2.com.

What problems is AWS Analytics solving and how is that benefiting you?

AWS Analytics helps businesses by enabling scalable data processing, realtime insights, cost efficient analysis, data driven decision making, advanced analytics, enhanced customer experiences, operational efficiency, market insights, compliance and security, and data monetization. It addresses these challenges and empowers businesses to make informed decisions, improve processes, and stay competitive. Review collected by and hosted on G2.com.

Verified User in Marketing and Advertising
UM
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
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. Review collected by and hosted on G2.com.

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

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

Sakharam R.
SR
Data Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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 Review collected by and hosted on G2.com.

What do you dislike about Amazon Redshift?

Some time it's lack during high workload but overall performance is too good highly recommend Review collected by and hosted on G2.com.

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

Verified User in Information Technology and Services
CI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic Review from User Profile
Incentivized Review
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. Review collected by and hosted on G2.com.

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

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

PRIYANSHU P.
PP
Test engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
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.

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

Hafiz A.
HA
Tutor
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
(Original )Information
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.
SS
DevOps Technical Lead
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.
AS
Associate Product Manager
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

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

Ramon S.
RS
Anaylst
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
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.