Do you want to load data from AWS S3 bucket to Snowflake? Setting up access to an S3 bucket from Snowflake can be done in 5 simple steps.

Want more details? Check out the link at the bottom for a detailed description of each step.

Step 1: Create IAM policy in AWS that allows a role to access the S3 bucket.

Step 2: Create role in AWS and attach the recently created policy to the role.

Step 3: Create Storage Integration in Snowflake.

Step 4: Retrieve ARN for the IAM user that was created automatically for your Snowflake account and attach STORAGE_AWS_IAM_USER_ARN and STORAGE_AWS_EXTERNAL_ID to the trust policy of the AWS role in tab Trust Relationships.

Step 5: Create a stage using the recently created storage integration as authentication. Excellent resource from Snowflake documentation: https://docs.snowflake.com/en/user-guide/data-load-s3-config-storage-integration