Setting database/catalog section of databricks jdbc driver url does not make it default

jneira — Thu, 10 Nov 2022 21:22:57 GMT

Hi, first of all thanks for the jdbc driver software.

I have been used it with almost no problems but today i tried to set a a a database by default other than hive_metastore.

I have followed the instructions and the example from the pdf jdbc driver guide:

jdbc:

databricks

://localhost:11000/default2;AuthMech=3;UID=

databricks;PWD=databricks

But the queries over schemas and tables from the database default2 fails cause it does not find them.

In fact you can set a non existing database and the driver does not complain.

am i using it wrong? is there another way to set the default database?

Thanks in advance!

Re: Setting database/catalog section of databricks jdbc driver url does not make it default

sanjevraj — Thu, 23 Feb 2023 21:49:01 GMT

For anyone looking for an answer I had to add ConnCatalog=<catalog-name> in the URL.