Data Sync from S3 and RedShift

piyushk
piyushk Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Adv Designer, Registered Posts: 55 ✭✭✭✭✭

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,

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 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).

Setup Info
    Tags
      Help me…