S3 connection to Snowflake

Hi,

I've been trying to connect s3 to Snowflake using storage integration, however, there is a policy in the s3 about the user that I cannot see how to modify to give access to the Snowflake user to alter this bucket. I followed the next configuration https://snowflakewiki.medium.com/connecting-snowflake-to-aws-ef7b6de1d6aa and it worked when no policy exists in the S3 bucket. However, I would like to ask how to add user access to the bucket to accept the Snowflake user because I'm getting this error from Snowflake when I try to create an external table:

Failure using stage area. Cause: [Access Denied (Status Code: 403; Error Code: AccessDenied)]

secondabhi_aws EXPERT
a month ago
Are you asking for s3 bucket policy?

Topics

Security, Identity, & Compliance Storage

Tags

IAM Policies Amazon S3 Access Grants

Language

English

Juan Palacio

asked a month ago123 views

1 Answer

Newest
Most votes
Most comments

The correct and recommended way for granting Snowflake access to your S3 bucket is explained, along with policy examples, in this documentation article: https://docs.snowflake.com/en/user-guide/data-load-s3-config-storage-integration

I suggest using the official documentation instead of third-party blog posts.

We're using this mechanism in my organisation, and it's both secure and easy to set up.

EXPERT

Leo K

answered a month ago