How to call azure databricks api from azure api management

[Check]

Hi,

Has anyone successfully configure azure apim to access databricks rest api ? If yes, appreciate  he can provide the setup guide for me as I am stuck at this point.

Thanks.

[Kaniz_Fatma]

Hi @Check, Configuring Azure API Management (APIM) to access Databricks REST API can be a bit tricky, but I’ll guide you through some potential approaches:

1. Using Environment Variables and cURL:

   • To execute Databricks API via a curl request, you need to set up two environment variables:
     • DATABRICKS_HOST: Set this to your Databricks workspace hostname (e.g., adb-xxxxx.azuredatabricks.net).
     • DATABRICKS_TOKEN: Obtain an access token for authentication.
   • Refer to the common basic setup to get the values for these variables¹.

2. Azure Service Principal:

   • You can implement the entire configuration process using an Azure Service Principal. This approach provides better security and control.
   • Follow the steps outlined in this guide to set up the Azure Service Principal for Databricks API acc...².

3. Databricks SQL Statement Execution API:

   • To access Databricks REST APIs, you must authenticate.
   • Consider using the Databricks SQL Statement Execution API 2.0 to run SQL statements from Databricks SQL warehouses. You can find the reference and tutorial here³.

Remember that each approach has its nuances, so choose the one that best fits your requirements.

If you encounter any specific issues during the setup, feel free to ask for further assistance! 😊