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

Learn from top reviewers

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 and Support Rating highest, with a score of 9.

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 From Top Reviewers

(1-5 of 38)

High Performance Data Warehouse

Rating: 9 out of 10
January 03, 2025
AV
Vetted Review
Verified User
Amazon Redshift
5 years of experience
  • Fast data retrieval from the table with complex joins via columnar storage and advanced query optimization techniques like parallel execution
  • Great reliable integration with AWS MSK using Amazon Redshift Streaming a low-latency streaming ingestion, AWS Glue and S3
  • Concurrency scaling and work load management - helps in segregating the load distribution based on roles
  • Decoupled storage and compute using RA3 instance type
  • Distribute cluster using Amazon Redshift data sharing i.e centralised write cluster with multiple readonly cluster
Cons
  • Data governance can be better
  • Data catalog and data discovery
  • Data lineage

Very good, but requires engg tuning

Rating: 7 out of 10
December 19, 2022
DK
Vetted Review
Verified User
Amazon Redshift
3 years of experience
  • Seamlessly integrates with the data in s3
  • Workbench provides useful way to query the tables within aws console
  • Postgres flavor of sql gives powerful capabilities such as window functions
Cons
  • Json support in sql is very limited.
  • Array type columns are missing. They are by default converted to strings
  • Sql workbench often goes unresponsive. I have to reload for the queries to run
  • A search option in the sql workbench would be great, which let's users search the whole db for a match on columns, tables etc

efficient, performant data store

Rating: 10 out of 10
August 09, 2021
NM
Vetted Review
Verified User
Amazon Redshift
6 years of experience
  • [Amazon] Redshift has Distribution Keys. If you correctly define them on your tables, it improves Query performance. For instance, we can define Mapping/Meta-data tables with Distribution-All Key, so that it gets replicated across all the nodes, for fast joins and fast query results.
  • [Amazon] Redshift has Sort Keys. If you correctly define them on your tables along with above Distribution Keys, it further improves your Query performance. It also has Composite Sort Keys and Interleaved Sort Keys, to support various use cases
  • [Amazon] Redshift is forked out of PostgreSQL DB, and then AWS added "MPP" (Massively Parallel Processing) and "Column Oriented" concepts to it, to make it a powerful data store.
  • [Amazon] Redshift has "Analyze" operation that could be performed on tables, which will update the stats of the table in leader node. This is sort of a ledger about which data is stored in which node and which partition with in a node. Up to date stats improves Query performance.
Cons
  • Amazon Redshift is a Managed Service. But it is Not a 100% managed service. We still need to configure it with WLM (Work Load Management) settings, and add Query Queues to make sure it's resources aren't wasted and it is performant at it's best state, all the time
  • [Amazon] Redshift has a concept of "Vacuum", which is an operation to claim the disk space back from deleted data/tables. They recently started doing automated vacuuming. Prior to that we had to do that at regular intervals, to claim the data back.

Powerful Data Management Tool

Rating: 9 out of 10
November 09, 2021
SS
Vetted Review
Verified User
Amazon Redshift
3 years of experience
  • Ease of setting up ETL
  • Uploading data into Redshift via AWS
  • Querying is quick
Cons
  • Missing option to restrict duplicate records
  • Lacks complex data sets like udf
  • Does not offer UI based querying & visualisation option like Looker

Amazon Redshift Review

Rating: 10 out of 10
April 02, 2021
AZ
Vetted Review
Verified User
Amazon Redshift
2 years of experience
  • Data retrieval experience really gets improved.
  • In terms of database management, it is really a no management at all in AWS. There is no even an OS to take care or worry about.
  • Auto or on-demand scaling is nice.
  • Integrates quite well with other products within the AWS ecosystem.
Cons
  • The number of connections is too small, I think at around 50 are allowed in parallel. With some ETL and apps connecting all the time, this brings an undesired possibility to some users or tools being unable to connect.
  • Needs some tuning.
  • The logging part is almost nonexistent.
  • Can be quite costly in the long run as opposed to just RDS or on-prem/dedicated solutions.
Return to navigation