Note: This site is currently "Under construction". I'm migrating to a new version of my site building software. Lots of things are in a state of disrepair as a result (for example, footnote links aren't working). It's all part of the process of building in public. Most things should still be readable though.

Access S3 From Redshift With boto3

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