Forum Discussion
Error when reading a ADLSGen2 csv from a synapse notebook while the private endpoint is enabled
Hi,
- With a SASS token i was able to read the data from the notebook (when the network access of the storage account is public) interactive mode.
- Also, i was able to read the data via a pipeline copy activity (when the synapse managed private enpoint is enabled (note at this time the storage account public access is disabled, plus a link service)
But when i tried to read the .csv data which is available inside the same ADLSGen2 container from a synapse spark notebook it fails wuth the below error?
AnalysisException: [PATH_NOT_FOUND] Path does not exist: abfss://<<root-folder>>@<<containername>>.dfs.core.windows.net/data/sales.csv
any support to identofy the cause of the issue is and how to get it resolved would be very much appreciated!
Thanks
Thanks for the hint v-gchenna-msft!
Was able to find and fix the issue, the problem was with the path. Now its working! 😊
4 Replies
Hi asankab ,
Thanks for using Fabric Community.
Can you please share the screenshot of the issue along with the code?
Do you have proper access to it? and did you cross checked the abfs path?
If you can provide these details, I would be able to guide you better.Here is the code, I am using to read the .csv
file_path = "abfss://[email protected]/data/sales.csv"df = spark.read.csv(file_path, header=True, inferSchema=True)df.show(5)Thanks for the hint v-gchenna-msft!
Was able to find and fix the issue, the problem was with the path. Now its working! 😊
