Open menu
-->

AWS Redshift Best Practices

Amazon Redshift is a fully managed, fast, petabyte-scale data warehouse service that is cost-effective and provides a simple way to efficiently analyze your data using your existing business intelligence tools.



Amazon Redshift is a fully managed, fast, petabyte-scale data warehouse service that is cost-effective and provides a simple way to efficiently analyze your data using your existing business intelligence tools. Amazon Redshift costs less than a tenth of most traditional data warehousing solutions and is optimisied for datasets ranging from a few hundred gigabytes to petabytes.

Cloud Conformity checks Amazon Redshift service according to the following rules:

AWS Redshift Automated Snapshot Retention Period
Ensure that retention period is enabled for Amazon Redshift automated snapshots.

Redshift Cluster Allow Version Upgrade
Ensure Version Upgrade is enabled for Redshift clusters to automatically receive upgrades during the maintenance window.

Redshift Cluster Audit Logging Enabled
Ensure audit logging is enabled for Redshift clusters for security and troubleshooting purposes.

Enable AWS Redshift Cluster Encryption
Ensure database encryption is enabled for AWS Redshift clusters to protect your data at rest.

Use AWS KMS Customer Master Keys for Redshift Clusters Encryption
Ensure Redshift clusters are encrypted with KMS customer master keys (CMKs) in order to have full control over data encryption and decryption.

Idle AWS Redshift Clusters
Identify idle AWS Redshift clusters and terminate them in order to optimize AWS costs.

Redshift Cluster In VPC
Ensure Amazon Redshift clusters are launched within a Virtual Private Cloud (VPC).

AWS Redshift Parameter Group Require SSL
Ensure AWS Redshift non-default parameter groups require SSL to secure data in transit.

Redshift Cluster Publicly Accessible
Ensure Redshift clusters are not publicly accessible to minimise security risks.

Redshift Cluster Default Port
Ensure Amazon Redshift clusters are not using port 5439 (default port) for database access.

AWS Redshift Desired Node Type
Ensure that your AWS Redshift cluster nodes are of given types.

AWS Redshift Disk Space Usage
Identify AWS Redshift clusters with high disk usage and scale them to increase their storage capacity.

AWS Redshift Node Type Generation
Ensure Redshift clusters are using the latest generation of nodes for performance improvements.

Redshift Cluster Default Master User Name
Ensure AWS Redshift database clusters are not using "awsuser" (default master user name) for database access.

Total Number of Redshift Nodes
Ensure that your AWS account has not reached the limit set for the number of Redshift cluster nodes.

AWS Redshift Reserved Nodes Failed Purchases
Ensure that none of your AWS Redshift Reserved Node purchases have been failed.

AWS Redshift Reserved Nodes Pending Purchases
Ensure that none of your AWS Redshift Reserved Node (RN) purchases are pending.

AWS Redshift Reserved Node Recent Purchases
Ensure Redshift Reserved Node purchases are regularly reviewed for cost optimization (informational).

AWS Redshift Reserved Nodes Purchase Recommendations
Upgrade Redshift cluster nodes to Reserved Nodes (RNs) by following Cloud Conformity recommendations for purchasing RNs.

Unused AWS Redshift Reserved Nodes
Ensure that your Amazon Redshift Reserved Nodes are being utilized.

Redshift Reserved Node Lease Expiration In The Next 30 Days
Ensure Amazon Redshift Reserved Nodes (RN) are renewed before expiration.

Redshift Reserved Node Lease Expiration In The Next 7 Days
Ensure Amazon Redshift Reserved Nodes (RN) are renewed before expiration.

Underutilized AWS Redshift Clusters
Identify underutilized Redshift clusters and downsize them in order to optimize AWS costs.

Enable Redshift User Activity Logging
Ensure that user activity logging is enabled for your Amazon Redshift clusters.