Amazon Redshift now supports integration with AWS Secrets Manager to simplify the management of Redshift administration (admin) credentials for your data warehouse. With this feature, Amazon Redshift works with AWS Secrets Manager to generate and manage your admin credentials when a database instance is created, modified, or restored. AWS Secrets Manager supports the entire lifecycle maintenance for your Amazon Redshift admin credentials which can help relieve you from complex credential management activities such as setting up custom AWS Lambda functions to manage password rotations.
Source:: Amazon AWS