Databricks, al Crear DataFrame muestra Error : Path does not exist

Juan Antonio Soto Mata 0

E creado el Punto de Montaje,

IMG_Data001.png

y al intentar crear el DataFrame obtengo el Error de Path does not exist.IMG_Data002.png

El archivo de datos se encuentra en la ruta expecificada : IMG_Data003.png

Llevo varios dias con este Error/Problema y no he podido solucionarlo, de antemano agradezco cualquier ayuda.

Atentamente.

ISC. Juan Antonio Soto

PRADEEPCHEEKATLA 90,246 Reputation points

2023-11-20T08:41:20.73+00:00

@Juan Antonio Soto Mata - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,246 Reputation points

2023-11-27T09:23:38.7566667+00:00

@Juan Antonio Soto Mata - Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

2 answers

PRADEEPCHEEKATLA 90,246 Reputation points

2023-11-10T07:50:55.8+00:00
@Juan Antonio Soto Mata - Thanks for the question and using MS QA platform.

As per the error message provide "Path does not exist." which mean dataframe cannot access the path which you have provided.

To resolve this issue, I would suggest you check if the path and permissions on the file which you are accessing by running the below command:

dbutils.fs.ls("/mnt/raw-brounce/dbo.Crime_Data_from.txt")

As per the repro, I'm able to access the file without any issues and able to load into dataframe as shown below:

In case, if you are having trouble creating a DataFrame in Azure Databricks. Can you please provide more information about the error message you are receiving? Also, can you confirm that you have mounted the correct path where the data file is located?

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Juan Antonio Soto Mata 0 Reputation points

2023-11-13T17:12:25.2066667+00:00

Ejecute lo indicado/Execute the indicated:

IMG_Data004.png

Ahora muestro el error al crear el DataFrame/Now I show the error when creating the DataFrame:

IMG_Data005.png

Saludos/Greetings.

PRADEEPCHEEKATLA 90,246 Reputation points

2023-11-15T06:49:10.45+00:00

@Juan Antonio Soto Mata - From the error message, it clearly says that the path was not found.

Can you please verify whether you are successfully mounted the storage account by running: dbutils.fs.ls('/mnt/raw-bronce')?

Juan Antonio Soto Mata 0 Reputation points

2023-11-28T19:09:57.2633333+00:00

You guided me in the solution, I changed the Assembly Point statement:

dbutils.fs.mount(source = 'wasbs://raw-bronce-0@datalakelabintegral.blob.core.windows.net', mount_point = '/mnt/mountpoint-bronce', extra_configs = {'fs.azure.account.key.datalakelabintegral.blob.core.windows.net':'xCUO1K/RYyA+APMV5m8QGntzaAmorkjpM3ITn1Z/uNLrsR3HbQeyd4szkI6a/U+gAWyfTVZYILAV+AStd2E3hQ=='})

Afterwards I could see the files contained in the Mount Point path:

IMG_Data006.png

I was now able to create the DataFrame:

IMG_Data007.png

Agradezco tu ayuda, quedo a tu atencion.

Saludos.

PRADEEPCHEEKATLA 90,246 Reputation points

2023-11-29T07:39:15.2066667+00:00

@Juan Antonio Soto Mata - Glad to know it helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

Databricks, al Crear DataFrame muestra Error : Path does not exist

2 answers

Your answer