Data Sync from S3 and RedShift

piyushk

Hi,

When I try to write data from S3 to RedShift, I am getting error as: No IAM role and S3 connection is using default credentials

I am using S3 with credentials as Environment.

I am following the documentation: https://academy.dataiku.com/integration-with-amazon-redshift/

Thanks,

Clément_Stenac

Hi,

In order to use environment credentials, you need to associate an IAM role to your Redshift cluster that has permission to read from S3. Then, you need to fill the "IAM role" setting in the Redshift connection (in DSS) to the ARN of the IAM role associated to the Redshift cluster.

This will allow DSS to pass the IAM role ARN to Redshift, and will allow Redshift to read the S3 data without credentials (which are normally passed by DSS).