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.<\/p>\n\n\n\n
Want more details? Check out the link at the bottom for a detailed description of each step.<\/p>\n\n\n\n
Step 1: Create IAM policy in AWS that allows a role to access the S3 bucket.<\/p>\n\n\n\n
Step 2: Create role in AWS and attach the recently created policy to the role.<\/p>\n\n\n\n
Step 3: Create Storage Integration in Snowflake.<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
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<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" 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…<\/p>\n