Access S3 From Redshift With boto3

December - 2021

This allows Redshift to access all S3 buckets

IAM - Create Roll

  • Click Redshift in the full list of services then click Redshift - Customizable under "Select your use case" for "Allows Redshift clusters to call AWS services on your behalf."
  • In the permissions policy screen, select AmazonS3FullAccess then go to Next Tags
  • Add any tags you'd like then click next.
  • Name the role: Redshift_S3_Read_Only_Access and change the description to note that it's for S3.