topic Re: Error when accessing the file from azure blob storage in Data Engineering

Error when accessing the file from azure blob storage

bonyfus — Tue, 17 Jan 2023 13:22:03 GMT

I am getting the following error when accessing the file in Azure blob storage

java.io.FileNotFoundException: File /10433893690638/mnt/22200/22200Ver1.sps does not exist.

Code:

ves_blob = dbutils.widgets.get("ves_blob")
try:
  dbutils.fs.ls(ves_blob )
except:
  raise FileNotFoundError("File '{f}' was not found.".format(f=ves_blob ))

If you look at the following mount the data bricks instance id attached (I assumed as this is in the url as adb-10433893690638.databricks.net)

/10433893690638/mnt/22200/22200Ver1.sps

when dbutils.fs.ls list the content I am assuming the mount path is only /mnt/22200/22200Ver1.sps.

Re: Error when accessing the file from azure blob storage

-werners- — Tue, 17 Jan 2023 13:52:54 GMT

that is certainly an invalid path, as the error shows.

with %fs ls /mnt you can show the directory structure of the /mnt directory, assuming the blob storage is mounted.

if not, you need to define the access ( URL etc.)

Re: Error when accessing the file from azure blob storage

bonyfus — Tue, 17 Jan 2023 14:20:26 GMT

It certainly is. I am not sure why the id is attached to the mount path. The actual mount path is /mnt/22200/22200Ver1.sps

Re: Error when accessing the file from azure blob storage

-werners- — Tue, 17 Jan 2023 15:06:13 GMT

that ID is added automatically if the file is not found.

If the file is found, it will not show up.

So whatever you put into the widget, it is not the correct path.