Configuring AWS IAM Authentication for Amazon Redshift and Amazon Redshift V2 Connectors

Configuring AWS IAM Authentication for Amazon Redshift and Amazon Redshift V2 Connectors

Create the Amazon Redshift Role

Create the Amazon Redshift Role

You must create the Amazon Redshift Role Resource Name (ARN) for secure access to Amazon Redshift resources.
  1. Log in to the
    AWS Console
    .
  2. Click
    Dashboard
    from the left panel.
    The
    AWS Service
    dashboard page appears.
  3. Click
    IAM
    .
    The
    Welcome to Identity and Access Management
    page appears.
  4. Click
    Policies
    from the left panel.
    The
    Policy
    page appears.
  5. Click
    Create Policy
    or select the required existing Amazon S3 Policy.
    You can edit or review the policy.
  6. Select
    Role
    from the left panel and click
    Create role
    .
    The
    Create role
    page appears.
  7. Select
    Redshift
    under the
    Choose the service that will use this role
    section.
  8. Select the required Amazon Redshift cluster under the
    Select your use case
    section.
  9. Click
    Next: Permission
    .
  10. Select the required
    Amazon S3 Policy
    in the
    Attach Permission Policies
    page.
  11. Click
    Next: Review
    .
  12. Specify the name of the role in the
    Create role
    review page.
  13. Click
    Create Role
    .
  14. Review the
    Role ARN
    ,
    Instance Profile ARNs
    , and
    Policy
    values in the
    Summary
    page.
The following example shows a sample Amazon Redshift Role Resource Name (ARN):
arn:aws:iam::123123456789:role/redshift_write
You must assign the Amazon Redshift Role that you created to the Amazon Redshift cluster to successfully perform the read and write operations.


Updated August 06, 2020