Forum Discussion

sureshabey1's avatar
sureshabey1
New Member
6 months ago
Solved

Read ADLS gen 2 file through Notebook using a Connection

Hi,  I am trying to run a simple read spark stream query with in fabric notebook.  I have used workspace identity mechanism for connection creation to storage account. https://learn.microsoft.com/...
Notebook
  • deborshi_nag's avatar
    deborshi_nag
    6 months ago

    Hello sureshabey1 

     

    Since you're using the fully qualified abfs location, I'm guessing you have not created the OneLake shortcut. Follow the Microsoft doc link you shared to create a OneLake shortcut pointing to the folder in your external storage. Use Workspace Identity when creating the shortcut. Once done, attach the notebook to the Lakehouse and use /Files/<shortcut name> instead of the abfs location. 

    Secondly, if your storage is behing a firewall, please check you've used Trusted Workspace Access.

     

deborshi_nag's avatar
deborshi_nag
Super User
6 months ago

Hello sureshabey1 

 

Since you're using the fully qualified abfs location, I'm guessing you have not created the OneLake shortcut. Follow the Microsoft doc link you shared to create a OneLake shortcut pointing to the folder in your external storage. Use Workspace Identity when creating the shortcut. Once done, attach the notebook to the Lakehouse and use /Files/<shortcut name> instead of the abfs location. 

Secondly, if your storage is behing a firewall, please check you've used Trusted Workspace Access.