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.
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.
Amazon Redshift delivers consistently high performance even with thousands of concurrent requests.
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.
What is Google BigQuery?
Google BigQuery is a PaaS service that supports most of the features of a DBMS.Learn more
What is Snowflake?
Snowflake is a cloud-based data processing and storage platform that allows you to combine data from many sources.Learn more