Connections > Amazon Redshift V2 connection properties > Configure IAM authentication
  

Configure IAM authentication

Configure AWS Identity and Access Management (IAM) authentication and create a minimal Amazon IAM policy for both the EC2 role and Redshift role.
For instructions, see the following How-to-Library article: Configuring AWS IAM Authentication