How to pass file path from Azure Storage into your Azure stored procedure

Question

Hi,
I have written a stored procedure that reads data from csv file and put it into multiple Postgres tables. It requires file path as a parameter and locally it works perfectly.

Call myProcedure('c:\file.csv'); // this works fine locally.

I have to make it work on Azure. I have created required tables and procedure on Azure Postgres. I have also written an azure function in Java which is connecting to database successfully. Now I need to take the CSV file from Azure Storage and pass it to stored procedure and execute it. The problem is that the path from Azure storage(SMB) is a URL(starts with https://...) whereas procedure expects path in Unix or Windows format. Is there a way I can make it work?

Call myProcedure('https://AzureURL/file.csv'); //doesn't work.
Any pointers will be helpful.

Thanks.

Answer 1

@Atul Kaushal Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused. If you are using Azure File Share, you can mount the share in the using Linux Function app

How to mount Blob storage as a file system with blobfuse
If you still have any question, I would like to work closer on this issue

Hope this helps!

Kindly let us know if the above helps or you need further assistance on this issue.

---------------------------------------------------------------------------------------------------------

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.