Usecase Universe

A collective of use cases for DevOps teams

Browse a variety of 200+ predefined templates to automate all your AWS actions

Amazon Redshift

24 Times Used
22 MAY 2019
Report Redshift clusters without tags.

This workflow sends a report of Redshift clusters which does not have tags established by their organisations. Which tags are missing can be found in the report generated.

Report Redshift clusters with high CPU utilization.

Sends a report of Redshift cluster if CPU utilization goes above than 90 %. Clusters with high CPU utilization should be rebooted this will improve the performance.

Enable version upgrade for redshift cluster if not already enabled

This workflow enables Version Upgrade feature on your Redshift cluster. AWS Redshift engine upgrades will occur automatically so the data warehouse service engine can get the newest features, bug fixes or the latest security patches released.

Report idle Redshift Clusters

Sends a report if any of the Redshift cluster present in your AWS account is appeared to be idle. Identifying and removing idle resources from your AWS account is best practice to reduce AWS costs.

Report If Default Master Username Used In Redshift Cluster

Sends a report if the default master username is used in the Redshift Cluster. Changing to a custom username enhances the protection of AWS Redshift Clusters against hacking.

Report Redshift Clusters which are not using desired node type

Sends a report, if AWS Redshift Clusters present in your aws account are not using desired node type established by your organization. Setting limits for the type of AWS Redshift cluster nodes will help you address internal compliance requirements and prevent unexpected charges on your AWS bill.

Report If Redshift Clusters Are Not Encrypted

Sends a report if the AWS Redshift Clusters are not encrypted. Enabling encryption ensures that there is no unauthorised access to the data.

Receive Redshift Cluster Updates Automatically

Sends a report if the Redshift Clusters are not configured to receive automatic updates during the maintenance window.

Ensure Redshift cluster is not publicly accessible

It is an AWS best practice to keep your Redshift clusters private for security reasons. If your cluster is public, any machine on the internet can establish a connection to it which can lead to SQL injection or DDoS attack.

Report If Redshift Clusters Use Default Port

Sends a report if any of the Redshift Clusters are using the default endpoint ports. This will provide an extra layer of security against port scanning and network attacks.