Amazon Redshift Features
What are the features of Amazon Redshift?
Data Management
- Data Integration
- Data Compression
- Data Quality
- Built-In Data Analytics
- In-Database Machine Learning
- Data Lake Analytics
Integration
- AI/ ML Integration
- BI Tool Integration
- Data lake Integration
Deployment
- On-Premise
- Cloud
Performance
- Scalability
Security
- Data Governance
- Data Security
Storage
- Data Types
Top Rated Amazon Redshift Alternatives
(159)
4.8 out of 5
Visit Website
Sponsored
Amazon Redshift Categories on G2
Filter for Features
Data Management
Data Integration | Based on 129 Amazon Redshift reviews and verified by the G2 Product R&D team. Consolidates, Cleanses and Normalizes data from multiple disparate sources. | 88% (Based on 129 reviews) | |
Data Compression | Based on 121 Amazon Redshift reviews and verified by the G2 Product R&D team. Helps save storage capacity and improves query performance. | 84% (Based on 121 reviews) | |
Data Quality | Based on 127 Amazon Redshift reviews and verified by the G2 Product R&D team. Eliminates data inconsistency and duplications ensuring data integrity. | 88% (Based on 127 reviews) | |
Built-In Data Analytics | Based on 123 Amazon Redshift reviews and verified by the G2 Product R&D team. SQL based analytics functions like Time series, pattern matching, geospatial analytics etc. | 81% (Based on 123 reviews) | |
In-Database Machine Learning | Based on 98 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. | 77% (Based on 98 reviews) | |
Data Lake Analytics | Based on 114 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 | 83% (Based on 114 reviews) |
Integration
AI/ ML Integration | Based on 97 Amazon Redshift reviews and verified by the G2 Product R&D team. Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities. | 79% (Based on 97 reviews) | |
BI Tool Integration | Based on 124 Amazon Redshift reviews and verified by the G2 Product R&D team. Integrates with BI Tools to transform data into Actionable Insights. | 86% (Based on 124 reviews) | |
Data lake Integration | Based on 115 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. | 86% (Based on 115 reviews) |
Deployment
On-Premise | As reported in 98 Amazon Redshift reviews. Provides On-Premise deployment options. | 81% (Based on 98 reviews) | |
Cloud | Based on 126 Amazon Redshift reviews and verified by the G2 Product R&D team. Provides Cloud deployment options (private or public cloud, hybrid cloud). | 89% (Based on 126 reviews) |
Performance
Scalability | Based on 130 Amazon Redshift reviews and verified by the G2 Product R&D team. Manages huge volumes of data, upscale or downscale as per demand. | 89% (Based on 130 reviews) |
Security
Data Governance | Based on 122 Amazon Redshift reviews and verified by the G2 Product R&D team. Policies, procedures and standards to manage and access data. | 87% (Based on 122 reviews) | |
Data Security | Based on 124 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 | 88% (Based on 124 reviews) | |
Role-Based Authorization | As reported in 44 Amazon Redshift reviews. Provides predefined system roles, privileges, and user-defined roles to users. | 87% (Based on 44 reviews) | |
Authentication | As reported in 49 Amazon Redshift reviews. Allows integration with external security mechanisms like Kerberos, LDAP authentication etc. | 85% (Based on 49 reviews) | |
Audit Logs | Provides an audit log to track access and operations performed on databases for regulatory compliance. This feature was mentioned in 44 Amazon Redshift reviews. | 81% (Based on 44 reviews) | |
Encryption | Provides encryption capability for all the data at rest using encryption keys. This feature was mentioned in 45 Amazon Redshift reviews. | 86% (Based on 45 reviews) |
Storage
Data Model | As reported in 50 Amazon Redshift reviews. Stores data tables as columns. | 84% (Based on 50 reviews) | |
Data Types | Based on 53 Amazon Redshift reviews. Supports multiple data types like lists, sets, hashes (similar to map), sorted sets etc. | 84% (Based on 53 reviews) |
Availability
Auto Sharding | Implements auto horizontal data partitioning that allows storing data on more than one node to scale out. This feature was mentioned in 44 Amazon Redshift reviews. | 87% (Based on 44 reviews) | |
Auto Recovery | As reported in 47 Amazon Redshift reviews. Restores a database to a correct (consistent) state in the event of a failure. | 82% (Based on 47 reviews) | |
Data Replication | Copy data across multiple servers through master-slave, peer-to-peer replication architecture etc. This feature was mentioned in 45 Amazon Redshift reviews. | 84% (Based on 45 reviews) |
Performance
Integrated Cache | Based on 45 Amazon Redshift reviews. Stores frequently-used data in system memory quickly. | 83% (Based on 45 reviews) |
Support
Multi-Model | Provides support to store, index and query data in more than one format. This feature was mentioned in 40 Amazon Redshift reviews. | 81% (Based on 40 reviews) | |
Operating Systems | Based on 44 Amazon Redshift reviews. Available on multiple operating systems like Linux, Windows, MacOS etc. | 84% (Based on 44 reviews) |
