I want to add my databricks hive database to pycharm. I installed the JDBC drivers etc. like described here. I'm using the latest driver: DatabricksJDBC42-2.6.36.1062 downloaded from https://www.databricks.com/spark/jdbc-drivers-download.
When I click on Test Connection I get:
Clicking on Specify Version results in:
When I enter the version number, e.g. 2.6.36 which is the driver version not the database version I get a "driver class not instantiable".
How do I get the database version number? Anything else that I miss? Or someone can point out a "better" HOWTO?