Amazon Redshift Features

Consolidates, Cleanses and Normalizes data from multiple disparate sources.

Helps save storage capacity and improves query performance.

Eliminates data inconsistency and duplications ensuring data integrity.

SQL based analytics functions like Time series, pattern matching, geospatial analytics etc.

Provides built in capabilities like machine learning algorithms, data preparation functions, model evaluation and management etc.

Allows data querying across data formats like parquet, ORC, JSON etc and analyze complex data types on HDFS

Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities.

Integrates with BI Tools to transform data into Actionable Insights.

Provides speed in data processing and capturing unstructured, semi-structured and streaming data.

Provides On-Premise deployment options.

Provides Cloud deployment options (private or public cloud, hybrid cloud).

Manages huge volumes of data, upscale or downscale as per demand.

Policies, procedures and standards to manage and access data.

Restricts data access at a cell level, mask or hide parts of cells, and encrypt data at rest and in motion

Provides predefined system roles, privileges, and user-defined roles to users.

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.

Provides encryption capability for all the data at rest using encryption keys.

Stores data tables as columns.

Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc.

Implements auto horizontal data partitioning that allows storing data on more than one node to scale out.

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.

Stores frequently-used data in system memory quickly.

Provides support to store, index and query data in more than one format.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Allows users to generate text based on a text prompt.

Condenses long documents or text into a brief summary.