CODEWITHSUNDEEP
snowflake-cloud-data-platform
Hennie de Nooijer
Hennie de Nooijer

Reputation: 21

Server failed to authenticate the request. (Status Code: 401; Error Code: NoAuthenticationInformation)]

Currently following the instruction for loading the data from Azure. Option no 1.

https://docs.snowflake.com/en/user-guide/data-load-azure-config.html

The storage integration with a service principal.

I'm keep getting the error :

Failure using stage area. Cause: [Server failed to authenticate the request. Please refer to the information in the www-authenticate header. (Status Code: 401; Error Code: NoAuthenticationInformation)]

I Azure I can see that there are AuthorizationErrors. Snowflake is reaching Azure but Azure thinks that it can't give access.

Anyone an idea?

Hennie

Upvotes: 0

Views: 4253

Answers (1)

Suzy Lockwood
Suzy Lockwood

Reputation: 1170

I agree that it looks like an access issue. Couple ideas:

  1. Perhaps the token expired? Try regenerating the SAS token and then recreate the Azure external stage with it.
  2. Do you have a firewall on your Azure storage? If so, follow these steps: https://docs.snowflake.com/en/user-guide/data-load-azure-allow.html#allowing-the-vnet-subnet-ids

Upvotes: 0

Related Questions