Query azure databricks table from azure function app

Question

Hi,

I have a table Invoice in Azure Databricks. I would like run a select query on this table and get the result in my azure function. My function app is .net and consumption plan.

I am unable to figure how to achieve this. Any help will be much appreciated.

Thanks

Answer 1

@Karpagam Gurumurthy ,

Thanks for reaching out to Q&A.

You can install Simba Spark ODBC Driver to query Azure Databricks via ODBC connection. However you wont be able to install ODBC driver due to the functions sandbox limitation

You could use Windows Containers on Azure App Service in which you have control over what drivers or custom software to install.

To run Functions inside the container you can use the following Windows Container for Azure Functions v3 : mcr.microsoft.com/azure-functions/dotnet:3.0-nanoserver-1809 and run it App Service: https://learn.microsoft.com/en-us/azure/app-service/quickstart-custom-container?pivots=container-windows&tabs=dotnet

Please note that, you won’t have the portal experience.

I hope this helps!

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.