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

[jneira]

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!

[sanjevraj]

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

It is in the documentation https://docs.databricks.com/integrations/jdbc-odbc-bi.html#databricks-jdbc under JDBC driver capabilities.