Amazon Redshift connection enables you to read data from or write data to Amazon Redshift.
You can use Amazon Redshift connections to create data objects and run mappings. The Developer tool uses the connection when you create a data object. The Data Integration Service uses the connection when you run mappings.
You can use AWS Identity and Access Management (IAM) authentication to securely control access to Amazon S3 resources. If you have valid AWS credentials and you want to use IAM authentication, you do not have to specify the access key and secret key when you create an Amazon Redshift connection.
You can create an Amazon Redshift connection from the Developer tool or the Administrator tool. The Developer tool stores connections in the domain configuration repository. Create and manage connections in the connection preferences.
When you run a mapping that reads data from an Amazon Redshift source and writes data to an Amazon Redshift target on the Spark engine, the mapping fails if the AWS credentials such as Access Key or Secret Key are different for source and target.