Databricks Learning 02 - Working With Notebooks - Error when running code to read CSV

mikedcxx — Mon, 08 Jan 2024 21:41:26 GMT

Hi,

I'm going through the Databricks course Get Started with Databricks for Machine Learning. When I run the following code in the 02 - Working With Notebooks notebook I get an error:

SELECT * FROM csv.`${DA.paths.datasets}/retail/customers.csv`

The error I receive is AnalysisException: [PATH_NOT_FOUND] Path does not exist: dbfs:/retail/customers.csv.; line 1 pos 14.

I have the proper permission set up according to the instructions in the notebook and installed everything in the notebook file provided on the course page. Does anyone know why this may be happening?

Re: Databricks Learning 02 - Working With Notebooks - Error when running code to read CSV

mikedcxx — Tue, 09 Jan 2024 18:46:50 GMT

Hi! Thanks for the response. Maybe you can clarify for me. I’m following this course: HTTPS://customer-academy.databricks.com/learn/course/1342/play/15169/demo-working-with-notebooks

I imported the notebook using the import URL on that page. I assume that would also import the data used in the notebook. If it is part of the import then where does the data reside in databricks so I can use the correct path?

topic Databricks Learning 02 - Working With Notebooks - Error when running code to read CSV in Training offerings

Databricks Learning 02 - Working With Notebooks - Error when running code to read CSV

Re: Databricks Learning 02 - Working With Notebooks - Error when running code to read CSV