Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Data Sync from S3 and RedShift

Level 3
Data Sync from S3 and RedShift

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,

0 Kudos
1 Reply
Dataiker
Dataiker

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).

0 Kudos