What is Amazon Redshift

Advantages

• 

  Key Management and End-to-end Encryption

  Amazon Redshift encrypts each block of the Amazon Redshift storage system using hardware-accelerated AES-256 as it is written to disk, using the default key or customer managed AWS Key Management Service (KMS) key.

• 

  Isolation of Compute Environments

  When a customer provisions an Amazon Redshift cluster in VPC, it’s locked down by default, so nobody has access to it. To grant other users inbound access to an Amazon Redshift cluster, you associate the cluster with a security group.

• 

  Automating Audits With APIs

  Amazon Redshift is integrated with AWS CloudTrail, a service that provides a record of actions taken by users in Amazon Redshift. Using the information collected by CloudTrail, you can determine the request that was made to Amazon Redshift, the IP address from which the request was made, and when it was made.

• 

  Efficient Storage and High-Performance Query processing

  Columnar storage, data compression, and zone maps reduce the amount of I/O needed to perform queries.

• 

  Limitless Parallelism

  Amazon Redshift delivers consistently high performance even with thousands of concurrent requests.

• 

  Result Caching

  When a query is executed, Amazon Redshift will know if there is a cached result from a previous run, and if the cached result is found and the data hasn’t changed, the cached result is returned immediately instead of rerunning the query.

• 

  Precise Access Control

  Fine-grained security control at the level of individual rows and columns allows users access to specific data.