Amazon Redshift

Amazon Redshift

About TrustRadius Scoring
Score 8.6 out of 100
Amazon Redshift

Overview

Recent Reviews

Redshift trumped Hive

9 out of 10
January 15, 2021
It is used within a few departments. It is used to solve certain legacy problems that have not yet been ported over to other more suitable …
Continue reading

Great Data Lake Solution

9 out of 10
December 30, 2020
Amazon Redshift is being used by some departments of our company to bring solution to data warehouse. Our data center was not large and …
Continue reading

Redshift Review

2 out of 10
November 30, 2019
Amazon Redshift was our enterprise data warehouse as a backend to our BI solutions.
Continue reading

Redshift is way too easy!

9 out of 10
September 27, 2019
Redshift is our data warehouse used by our organization. It takes data from different sources and put them together in Redshift for our …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Amazon Redshift, and make your voice heard!

Pricing

View all pricing

Redshift Managed Storage

$0.24

Cloud
per GB per month

Current Generation

$0.25 - $13.04

Cloud
per hour

Previous Generation

$0.25 - $4.08

Cloud
per hour

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Amazon Redshift?

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Amazon Redshift Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.

Reviewers rate Usability highest, with a score of 10.

The most common users of Amazon Redshift are from Mid-sized Companies (51-1,000 employees) and the Computer Software industry.

Comparisons

View all alternatives

Reviews and Ratings

 (180)

Ratings

Reviews

(1-25 of 34)
Companies can't remove reviews or game the system. Here's why
Sameera Srivastava | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is primarily used as a data management solution by Product Analytics Group. We currently have various sources of capturing data like Heap, Delighted, Salesforce and it is convenient to build an ETL from these sources to Redshift. This enables us to merge all these data sources into single view in a BI tool like Power BI
Score 10 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is our Data Warehouse, where we store our processed data (Hot data) for various initiatives like BI, Analytics, DataScience, etc

We also use Amazon Redshift Spectrum as our Data Lake, where we store raw (un-processed) data (Cold data) for historical analysis, trends, etc

We store various standard data in Redshift like:
Bronze (ETL-ed data),
Silver (Materialized Views data), and
Gold (Rollups/Aggregated/Dashboard-ready data) in [Amazon] Redshift





Prashast Vaish | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
I am working with an insurance client where a lot of claims and policy data comes in every day, we use amazon redshift to perform ETL and analyze the data to gain business insights.
Amazon redshift is an integral part of our data analysis.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We have decided to purchase Amazon Redshift since we started the project of building a new "data lake," so the first step was to decide which tool would be more appropriate to use as a data warehouse. Since we have everything on the cloud, we choose Amazon Redshift to connect our current tools on AWS and integrate the data.
Arthur Zubarev | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is a PostgreSQL based solution was seen as a drop-in replacement for several Postgres based databases (or schemas in Postgres parlance).
The eventual product: a Bill Inmon principles-based Data Warehouse served as a point or source of a single truth. It aided in decision making, historical outlooks and forecasting across various organizational verticals - the Finance, Marketing, and Medical Research. It was also possible to deliver data extracts to 3rd parties or visualize data on demand.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Amazon Redshift for our insights platform in our R&D space. Our team creates reports and dashboards on tools for business use. Amazon Redshift provides greater supply chain visibility, increased information on product movement, and high efficiency at a much faster rate.
Bojan Sovilj | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
Cloudwalker offers analytic services for the gambling industry. The gambling industry has vast amounts of data that are high speed and variability. Our services from Redshift help gambling companies have better control of their bookmaking product, have a complete view of customers betting history, helps with detecting problematic accounts, etc.
December 30, 2020

Redshift Review for you!

Duncan Hernandez | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is being used by our whole organization. It is our primary tool for our data warehouse. We decided to switch to a cloud database because our in house servers just weren't able to keep up with our need for fast data delivery. We can adjust the speed up to where we need it to be and it has been very useful.
December 30, 2020

Great Data Lake Solution

Score 9 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is being used by some departments of our company to bring solution to data warehouse. Our data center was not large and scalable enough to have big scale data warehouse. So we take Amazon Redshift as one of the data warehouses we use to help us in data transformation.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are performing a POC (proof of concept) across multiple cloud vendors, and we have evaluated GCP, Azure, and Amazon. We plan to go on-site cloud from on-premises, and we will evaluate all databases across all cloud providers. We are making the current database over Amazon Redshift, if it can help us do the exact same job as we have on-premises SQL Server. The on-prem option is good for replication and security, and we are evaluating how good it can be on ML application support.
Score 9 out of 10
Vetted Review
Verified User
Review Source
My team is handling all the marking activities for all different product verticles for our company. We get a lot of streaming data that we focus on marketing. We also store this data carry out annual audits and aggregations to analyze our marketing progress. Amazon Redshift helped us with this, and it was a breeze enabling it in our environment as we were already on AWS.
Akshaya Bhardwaj | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Amazon RedShift is used in all departments and accounts. This tool is newly integrated into the system so as to work with the data on the cloud. There are various projects which are moving from SQL servers to ARS because of its capacity of working and managing the data in the cloud.
Score 7 out of 10
Vetted Review
Verified User
Review Source
AWS Redshift is the cloud-based data warehouse where we store our application level datasets and is used further for insights from the stored dataset. It improves the decision support for our business based on data analytics on a large set of real-time datasets which force the business processes to the next level. It provides good performance with high availability for essential data analysis and valuable intelligence.
Vibhakar Prasad | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
1)ETL(Talend) data from source applications (Salesforce, Jira, OpenAir, NetSuite, Sharepoint, Active Directory, Office 365, etc.) to S3 bucket and from S3 bucket push data to Redshift (sync time is 10 minutes intervals. Data is available almost real-time only lagging 10 minutes).
2) All Department use it—Engineering, Sales, and Marketing.
3) As I said data is almost in real-time, so it is very useful for taking real-time decisions for upper management. We also reduced Salesforce licenses, because most of the users only used it to see reports. Now they are happy to used Redshift.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Redshift is being used by engineering for our data warehouse or data lake, if you will. It's part of our ETL pipeline, where the data is used to form dashboards and analytical queries across all of our initially segregated data. So it is kind of a source of truth linking data across the company. These dashboards are accessible across other departments in the organization. The data is consumed by everyone, not just engineers.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is being used as our primary analytic data-warehouse. This allows our data and analytic team to build report and query data without going directly to our production database. It is a central data repository from external data sources as well, data we import from 3rd parties and segment.
Jacob Biguvu | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Capital One has many LOBs (line of businesses). I have supported IAM and Commercial LOB. They are using Redshift as a data warehouse solution. Oracle is not a Data Warehouse solution but was being used when the application was on on-premises. When they wanted to migrate all data to the Cloud, they chose Redshift as a solution to move the data from Oracle. Oracle is not a data warehouse solution. Redshift has been found as a good solution because of its unique features such as its MPP architecture, columnar architecture, and storage capacity.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it as our data warehouse for reporting purposes.

My company used it solely for reducing the performance overhead of running long SQL queries. The seamless implementation of Redshift allowed us to get the data ready to go for our customers to run the reports they need. It is currently used by a few customers, but we are trying to get each of our customers to use this rather than using the traditional OLTP database.
Brendan McKenna | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Amazon RedShift is used primarily by our in house data analytics and psychometric department. When we process the results of physician board certification exams we have a workflow which integrates the newly processed scoring data into RedShift which is used for analytical purposes. The data is denormalized and stored in a fashion which makes it overall more optimal for querying purposes. This data serves as the basis for final scoring calculations for a given exam. The data analytics department is then able to run their statistical analysis against the housed sets of data to ultimately determine the final test scores. We also house an "item bank" of exam questions from past exams which are used as the basis for future exams. Scoring is correlated to the item bank to help determine which questions performed well and which ones exam takers had difficulty with. RedShift is a great tool for our IT department because it helps share the responsibility of having to secure such sensitive data. Amazon is a company which we feel very confident with and RedShift has proven to be extremely robust and fast. It is nice to be able to so easily perform backups of data and rest more assured that it is in a safe form and not something which our own IT department has to manage along with all of our internally hosted transactional databases.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Amazon Redshift is being used as the main data warehouse across the whole organization. It provides essential business performance data and valuable intelligence. Different departments utilize it for a variety of operations, and decision makers rely on the data analytic tools built upon its data for tracking and enhancement, wherever needed.
Kyle Reichelt | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
Redshift is currently being used to house normalized client data pulled from various third-party endpoints. It houses the data that is both being accessed directly by our business intelligence and CRM platform, as well as made available via our own API gateways. It was chosen for its ability to support a "big data" environment with high availability.
Gavin Hackeling | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Amazon Redshift and Redshift Spectrum for our data warehouse. Our production transactional datastores are continuously replicated to Redshift and transformed into fact tables. Redshift is maintained by the data team, but it is used by analysts on most teams, including business intelligence, product, and customer support. Redshift is our source of truth; it provides information about business processes that the team needs to make decisions.