Amazon Redshift Features

Based on 133 Amazon Redshift reviews and verified by the G2 Product R&D team. Consolidates, Cleanses and Normalizes data from multiple disparate sources.

Based on 125 Amazon Redshift reviews and verified by the G2 Product R&D team. Helps save storage capacity and improves query performance.

Based on 131 Amazon Redshift reviews and verified by the G2 Product R&D team. Eliminates data inconsistency and duplications ensuring data integrity.

Based on 127 Amazon Redshift reviews and verified by the G2 Product R&D team. SQL based analytics functions like Time series, pattern matching, geospatial analytics etc.

Based on 102 Amazon Redshift reviews and verified by the G2 Product R&D team. Provides built in capabilities like machine learning algorithms, data preparation functions, model evaluation and management etc.

Based on 118 Amazon Redshift reviews and verified by the G2 Product R&D team. Allows data querying across data formats like parquet, ORC, JSON etc and analyze complex data types on HDFS

Based on 101 Amazon Redshift reviews and verified by the G2 Product R&D team. Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities.

Based on 128 Amazon Redshift reviews and verified by the G2 Product R&D team. Integrates with BI Tools to transform data into Actionable Insights.

Based on 119 Amazon Redshift reviews and verified by the G2 Product R&D team. Provides speed in data processing and capturing unstructured, semi-structured and streaming data.

Provides On-Premise deployment options. This feature was mentioned in 102 Amazon Redshift reviews.

Based on 130 Amazon Redshift reviews and verified by the G2 Product R&D team. Provides Cloud deployment options (private or public cloud, hybrid cloud).

Based on 134 Amazon Redshift reviews and verified by the G2 Product R&D team. Manages huge volumes of data, upscale or downscale as per demand.

Based on 126 Amazon Redshift reviews and verified by the G2 Product R&D team. Policies, procedures and standards to manage and access data.

Based on 128 Amazon Redshift reviews and verified by the G2 Product R&D team. Restricts data access at a cell level, mask or hide parts of cells, and encrypt data at rest and in motion

As reported in 47 Amazon Redshift reviews. Provides predefined system roles, privileges, and user-defined roles to users.

As reported in 52 Amazon Redshift reviews. Allows integration with external security mechanisms like Kerberos, LDAP authentication etc.

Provides an audit log to track access and operations performed on databases for regulatory compliance. This feature was mentioned in 47 Amazon Redshift reviews.

Based on 48 Amazon Redshift reviews. Provides encryption capability for all the data at rest using encryption keys.

Stores data tables as columns. This feature was mentioned in 53 Amazon Redshift reviews.

As reported in 56 Amazon Redshift reviews. Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.

As reported in 47 Amazon Redshift reviews. Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.

As reported in 50 Amazon Redshift reviews. Restores a database to a correct (consistent) state in the event of a failure.

Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc. This feature was mentioned in 48 Amazon Redshift reviews.

Based on 48 Amazon Redshift reviews. Stores frequently-used data in system memory quickly.

As reported in 43 Amazon Redshift reviews. Provides support to store, index and query data in more than one format.

Available on multiple operating systems like Linux, Windows, MacOS etc. 47 reviewers of Amazon Redshift have provided feedback on this feature.

Allows users to generate text based on a text prompt. This feature was mentioned in 20 Amazon Redshift reviews.

As reported in 19 Amazon Redshift reviews. Condenses long documents or text into a brief summary.