Snowflake Data Cloud Connector

Back Next

Configuring storage integration for Microsoft Azure Data Lake Storage Gen2

Create a storage integration to allow Snowflake to read data from the Microsoft Azure Data Lake Storage Gen2 container.

You can refer to the Snowflake documentation to perform the following steps:

Create a Cloud Storage Integration in Snowflake.

Retrieve the Cloud Storage Service account for your Snowflake account. See Granting access to the storage locations

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 adls_int to role myrole;

Watch

Comments

0 COMMENTS

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