Following the link - azure-synapse-workspace-how-to-read-an-excel-file.html, I am trying to read a file in Azure Synapse (Pyspark) notebook. I keep getting the File Not found error.
FileNotFoundError : [Errno 2] No such file or directory
I am using a Python file read and want to read the file as a File Stream.
f_read = open(mountfilename, "r")
records = Medline.parse(f_read)
The Medline is a custom library and expects the file handle to be passed. I am using the SAS Token to get the file over https. I am able to download the file successfully in a browser which confirms the file exists and the token works but it wouldn't be the case with the Pyspark notebook. Am I missing any configuration here?
Edit: I was able to achieve this on Databricks with the file mapped to DBFS and reading the file like above snippet. Trying to see if I can run the Databricks notebooks on Synapse with minimal changes.



