Amazon Redshift

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.

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.

Amazon Redshift Alternatives

Google BigQuery

Google BigQuery

What is Google BigQuery?

Google BigQuery is a PaaS service that supports most of the features of a DBMS.

Learn more
Snowflake

Snowflake

What is Snowflake?

Snowflake is a cloud-based data processing and storage platform that allows you to combine data from many sources.

Learn more
Clickhouse

Clickhouse

What is Clickhouse?

ClickHouse is an open-source columnar relational DBMS from Yandex for fast processing of analytical SQL queries on structured big data in real time.

Learn more

How do you rate the tool?