Unable to connect the ADLS to snowflake

Question

I am not able to connect the ADLS to snowflake. I requested azure to create the connection but I don't see the user that starts with Snowflake... when I create a role in IAM.

Answer 1

Hi Annu,

Appreciate your help!

Below are the steps I used:

Created the STORAGE INTEGRATION in Snowflake.

Used the describe command to get to Microsoft sign in.

Once I check the consent box, it takes me to the Snowflake site.

When I try to grant access to the storage account, I don’t see the snowflakeaccount created.

Answer 2

Hi Purnima Sharma ,

Thankyou for sharing required details regarding the query.

Post creating the storage integration object in snowflake, you might need to provide consent to the storage integration object for accessing Azure blob storage by using the following command:

Desc Storage Integration <objectname>

Once you do that, you would get AzureConsentURL , login using that URL.

For more details, kindly check out the following video that explains the process clearly : Snowflake - Loading data from Azure

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou