Amazon Redshift Federated Query with RDS PostgreSQL

   Go back to the Task List
  « 4. Configure Secret Manager    6. Launch Redshift Cluster »

5. Configure Redshift Role

You create IAM Role for the Redshift cluster which authorizes the cluster call to the Secrets Manager.

  1. Goto the IAM Management console and click on the Roles menu in the left and then click on the Create role button.

    IAM Role

  2. On the next screen, select Redshift - Customizable as the service \ use case and click on the Next: Permissions button.

    IAM Role

  3. On the next screen, select PowerUserAccess as the policy and click on the Next: Tags button.

    IAM Role

  4. On the next screen, click on the Next: Review button.

  5. On the next screen, type in dojoredshiftrole as the role name and click on the Create role button.

    IAM Role

  6. The role is created in no time. Please make note of the Role ARN as you need it later in the workshop. The next step is to launch the Redshift cluster.