How to set up jdbc template for databricks

[saidul choudhury]

The below mentioned site has jdbc template for many data sources and using that as a reference I have created the template for databricks using the hive template. But I don't understand exactly how it works and if I have set it up correctly or not

https://community.spotfire.com/wiki/tibco-spotfire-jdbc-data-access-connectivity-details#toc-9

 

databricks

com.simba.spark.jdbc.Driver

 

jdbc:spark://<host>:<port>/default

 

TABLE,EXTERNAL TABLE

true

true

SHOW TABLES

10000

100

 

 

#$$name$$

 

CREATE TABLE $$name$$ $$column_list$$

 

 

DROP TABLE $$name$$

 

true