Connecting Databricks from Azure App Service using Hive-JDBC Driver

You may have a use case where you need to query and report data from Hive. Azure Databricks supports various Business Intelligence tools (ref: https://docs.azuredatabricks.net/user-guide/bi/index.html) to serve the purpose.

In this example, we’ll be creating an Azure App Service which will fetch records using Hive-JDBC driver.

1. Create a sample table at Azure Databricks.

Create a new/use an existing table

2. Generate a user token

Go to Account icon > User Settings > Access Tokens > Generate New Token

3. Note down the JDBC URL. The JDBC/ODBC option is available only with the Premium plan.

Azure Databricks — Cluster Settings screen > Advanced Options> JDBC/ODBC tab

4. Download a JDBC Driver with all the dependencies from: https://docs.azuredatabricks.net/user-guide/bi/workbenchj.html. In my case, it’s uber-hive-jdbc-1.2.1.jar