Snowflake destination staging error

asked 2020-02-03 10:36:44 -0600

anonymous user

Anonymous

Receiving this error when trying to insert data into snowflake destination using s3 staging:

SNOWFLAKE_59 - Could not get a Stage File Writer Instance to write the records: 'Access Denied'

The key provided should have access to the S3 bucket

In the documentation: https://streamsets.com/documentation/...

it also mentions needing s3:GetBucketLocation, why?

edit retag flag offensive close merge delete

Comments

As per the docs, can you confirm that the role / access key pair you've configured has the permissions to write to Amazon S3 -- including s3:GetBucketLocation and s3:PutObject? I suspect these are required by Snowflake.

iamontheinet gravatar imageiamontheinet ( 2020-02-11 13:41:08 -0600 )edit