Amazon Redshift Federated Query with RDS PostgreSQL

   Go back to the Task List
  « 3. Launch RDS Instance    5. Configure Redshift Role »

4. Configure Secret Manager

You configure RDS Instance credential secret in Amazon Secrets Manager which is later used for the federation configuration.

  1. Goto the AWS Secrets Manager console and click on the Store a new secret button.

    AWS Secrets Manager

  2. On the next screen, select Credentials for RDS database option. Type in postgres as the user name. Type in Password1! for the password. Select dojordsinstance RDS instance and click on the Next button.

    AWS Secrets Manager

  3. On the next screen, type in dojordsinstancekey for the secret name and cick on the Next button.

    AWS Secrets Manager

  4. On the next screen, keep everything default and click on the Next button.

  5. On the next screen, click on the Store button. The secret is created. Open the secret detail and make note of the Secret ARN as you need it later when configuring the federation.

    AWS Secrets Manager

  6. In the next step, you configure IAM Role for the Redshift Cluster.