Query azure databricks table from azure function app

Karpagam Gurumurthy 41 Reputation points
2022-02-04T19:43:49.867+00:00

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

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,518 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,031 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,535 questions
0 comments No comments
{count} votes

Accepted answer
  1. MughundhanRaveendran-MSFT 12,446 Reputation points
    2022-02-07T10:54:30.9+00:00

    @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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful