Could you please share you inputs on the posted question?
To Manage Authentication, Use either of the following two methods:
>> Create an Access Key ID and Secret Access Key. Applicable when Secure Agent is not installed on Amazon Elastic Compute Cloud (EC2) system and you want to run tasks on Secure Agent. Provide the values for Access Key ID and Secret Access Key when you configure the Amazon Redshift connection.
>> Configure AWS Identity and Access Management (IAM) Authentication. For enhanced security. Applicable when you install Secure Agent on Amazon EC2 system and you want to run tasks on Secure Agent installed on the EC2 system. If you use IAM authentication, do not provide Access Key ID and Secret Access Key explicitly in the Amazon Redshift connection. Instead, you must create an Redshift Role Amazon Resource Name (ARN), add the minimal Amazon S3 bucket policy to the Redshift Role ARN, and add the Redshift Role ARN to the Redshift cluster.