Databases

What is Amazon Redshift

Amazon Redshift is columnar cloud-based data warehouse platform, which is useful for systems with a constant load – such as regular reporting and machine learning routines. Amazon Redshift provides the ability to quickly query structured data using familiar SQL-based clients as well as business intelligence (BI) tools through standard ODBC and JDBC connections.

Book a Discovery Call → View Results

Advantages

Why choose Amazon Redshift

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.