You need to set the time duration during which an IAM user can use the dynamically generated temporary credentials to access the AWS resource. Enter the temporary credentials duration in seconds in the advanced source and target properties for the Amazon S3 and Amazon Redshift connectors in a mapping. The default is 900 seconds.

If you require more than 900 seconds, you can set the time duration to a maximum of 12 hours in the AWS console and then enter the same time duration in this property.

The following image shows an example of the configured

temporary credential duration

in the source properties in an Amazon S3 connection:

For more information about the advanced properties, see Amazon Redshift V2 advanced properties and Amazon S3 V2 advanced properties.