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 an Amazon Redshift V2 Connection

Create an Amazon Redshift V2 Connection

When you set up an Amazon Redshift V2 connection, you must configure the connection properties.
To run a mapping on Secure Agent installed on an EC2 system, you must not provide the
Access Key ID
and
Secret Access Key
when you create an Amazon Redshift V2 connection.
The following image shows the sample values in the Amazon Redshift V2 connection properties:
The Secure Agent uses the
Username
,
Password
, and
JDBC URL
properties to validate the connection.
Provide the Amazon Redshift Role Resource Name (ARN) in the
AWS_IAM_ROLE
option in the
UnloadOptions Property File
and
CopyOptions Property File
properties when you create a task. The Secure Agent uses the Amazon Redshift Role Resource Name (ARN) associated with the IAM Role to access the data from the Amazon Redshift target. When you run the mapping task, the Secure Agent validates the IAM policy.


Updated August 06, 2020