S3 connection to Snowflake

0

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)]

  • Are you asking for s3 bucket policy?

1回答
2

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.

エキスパート
Leo K
回答済み 3ヶ月前
profile picture
エキスパート
レビュー済み 3ヶ月前
profile pictureAWS
エキスパート
iBehr
レビュー済み 3ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ