Snowflake Data Cloud Connector

Back Next

Configuring storage integration for Amazon S3

Create a storage integration to allow Snowflake to read data from the Amazon S3 bucket.

Create a Cloud Storage Integration in Snowflake.

Retrieve the Cloud Storage Service account for your Snowflake account.

Grant the service account permissions to access the bucket objects.

Create a custom IAM role.

Assign the custom role to the Cloud Storage Service account.

Grant permissions for the role to create an external stage.

The role must have the CREATE STAGE privilege on the schema and the USAGE privilege on the storage integration.

For example, run the following commands to grant these privileges:

grant create stage on schema public to role myrole; 
grant usage on integration s3_int to role myrole;

For more information about how to configure a storage integration for Amazon S3, see Snowflake storage integration to access Amazon S3 in the Snowflake documentation.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.