topic Re: Unable to read from azure blob using SAS token\\ in Data Engineering

Unable to read from azure blob using SAS token\\

sunkam — Sun, 07 Aug 2022 17:40:57 GMT

I have tried many times all the answers from the internet and stackover flow

I have already created the config section before this steps, it passed but this below step is not executing.

Re: Unable to read from azure blob using SAS token\\

jakubk — Mon, 08 Aug 2022 01:26:29 GMT

isnt the sas token meant to be passed in as part of the URL? I can't see it in your example

https://docs.microsoft.com/en-us/azure/storage/common/media/storage-sas-overview/sas-storage-uri.png

https://docs.microsoft.com/en-us/azure/storage/common/storage-sas-overview

Re: Unable to read from azure blob using SAS token\\

Vidula — Wed, 07 Sep 2022 12:29:16 GMT

Hi @santh s

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: Unable to read from azure blob using SAS token\\

Debayan — Mon, 08 Aug 2022 13:02:12 GMT

@santh s , Could you please try to use the steps mentioned below in a notebook (Data location, type and account access key can be set before reading the data) :

https://docs.databricks.com/_static/notebooks/data-import/azure-blob-store.html

Re: Unable to read from azure blob using SAS token\\

aockenden — Wed, 10 Jan 2024 14:52:15 GMT

We were getting this problem when using directory-scoped SAS tokens. While I know there are a number of potential issues that can cause this problem, one potential explanation is that it turns out there is an undocumented spark setting needed on the cluster to enable directory-scoped SAS tokens. In your cluster's Spark config, add the following:

spark.hadoop.fs.azure.account.hns.enabled true

That solved it for us.