Usecase Universe

A collective of use cases for DevOps teams

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

Create Template
Solutions
All Categories

Amazon Redshift

24 Times Used
22 MAY 2019
Redshift Clusters
Amazon Redshift
Reporting

Sends report of Redshift cluster CPUUtilization.

Redshift Clusters
Amazon Redshift
None

Redshift Clusters (Inventory)

Redshift Idle Clusters
Amazon Redshift
Cost Saving
Cost Saving

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.

Redshift Cluster Default Master Username
Security
Security
Amazon Redshift

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.

Checking Redshift Snapshot Retention Period
Security
Security
Amazon Redshift

Sends a report if the automated snapshots on Redshift are disabled (snapshot retention period set to zero). Automated snapshots are advantageous over manual as they improve data protection and recoverability.

Delete idle Redshift Clusters
Amazon Redshift
Operational Excellence

.

Enables Automated Backup for redshift cluster if not already enabled
Reliability
Backup
Amazon Redshift

It is AWS best practice to enable automated backups for your Redshift cluster so that in case of unexpected failures data can be recovered

Report If Redshift Cluster Is Publicly Accessible
Security
Security
Amazon Redshift

Sends a report if the Redshift Clusters are publicly accessible. This will ensure that unauthorised machines cannot establish a connection to the clusters.

Redshift Clusters CPUUtilization
Amazon Redshift
Other
Reporting

The template measures & provides you with actionable CPUUtilization data for Redshift Clusters - so you can view under & over-utilized resources & take action.

Report Redshift clusters without tags.
Amazon Redshift
Operational Excellence
Operational Excellence

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.

Redshift Clusters with High CPU Utilization
Amazon Redshift
Other

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 Redshift Cluster Allow Version Upgrade
Amazon Redshift
Security

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.

Redshift Cluster Allow Version Upgrade
Amazon Redshift
Security
Security

Sends a report if Version Upgrade is not enabled for Redshift Clusters. Having it enabled ensures that your Clusters remain up to date with the latest patches and upgrades.

Redshift Clusters Not Using Desired Node Type
Security
Amazon Redshift
Security

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.

Unencrypted Redshift Clusters
Security
Security
Amazon Redshift

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