How to Connect to Databricks Delta table using JDBC?

Connect Databricks Delta tables using JDBC 
(Microsoft Azure)


This post covers Databricks Delta JDBC connection cobnfiguration.

Step 1

Download Databricks Spark JDBC driver from below location. This might require to fill in basic information before the download. After you fill in the required field you would receive Driver download links to the email you provided in the form.
keep the Jar into C:\Downloads (or any location. this jar need to be added to the classpath) location.



Step 2

-> Open Databricks URL.
-> Navigate to Cluster tab and click on cluster.
-> In the below page copy any one of the JDBC URLs. (you may need to click on advanced settings under configuration tab in cluster config page)



Step 3

Navigate to top right Corner to the profile page and click on profile.
Generate Token and keep it safely in local machine.




Step 4

Below is the scala program to connect to Databricks Delta from Outside Azure/Cloud environment.
I have used Eclipse IDE for this. 



Comments

  1. Is this driver supports update???
    https://docs.databricks.com/spark/latest/spark-sql/language-manual/update.html

    ReplyDelete

Post a Comment

Your Comments are more valuable to improve. Please go ahead

Popular posts from this blog

Apache Hive Error Resolution Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/hive/conf/HiveConf

JSON Exception Causes: Exception in thread "main" groovy.json.JsonException: Lexing failed on line: 1, column: 1, while reading 'c', no possible valid JSON value or punctuation could be recognized