Skip to main content
TrustRadius
Amazon Redshift

Amazon Redshift

Overview

What is Amazon Redshift?

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

Read more
Recent Reviews

Redshift trumped Hive

9 out of 10
January 15, 2021
Incentivized
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
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

Return to navigation

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
Return to navigation

Product Demos

ETL From Amazon RDS to Amazon Redshift with using AWS Glue Service

YouTube

Introduction to Query Scheduler for Amazon Redshift

YouTube

ETL From AWS S3 to Amazon Redshift with AWS Lambda dynamically.

YouTube

Amazon Redshift Tutorial | AWS Tutorial for Beginners | AWS Certification Training | Edureka

YouTube
Return to navigation

Product Details

What is Amazon Redshift?

Amazon Redshift Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
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).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(209)

Attribute Ratings

Reviews

(1-25 of 37)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using Amazon Redshift as our main data warehouse to store most of our data, the whole process consists in extract the data from different sources, we do some transformations when needed and the data is finally stored in Amazon Redshift in order to be used afterward by one of our Business Intelligence tools.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Amazon Redshift for structured data warehousing. It allows us to store, retrieve, and analyze large volumes of structured data quickly and efficiently. It is used to support decision-making, identify trends, and gain insights into the business. Furthermore, we use Amazon Redshift can be used to create dashboards, generate reports, and perform ad-hoc queries on data to support business intelligence and analytics efforts. We also use it to support our customer service applications or fraud detection systems
Dileep Kumar | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
I use it as the data warehouse of our clients. I use it to build data transformations of user activity logs to ML features. I use the sql workbench to explore datasets and understand data schemas. Post that, I generally connect to the warehouse either through dbt or from jupyter notebooks.
Sameera Srivastava | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
ResellerIncentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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
Incentivized
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.
Return to navigation