You can try to prefix the path with dbfs:/

Please also do tests from within databricks without using the JDBC driver.

Please also use the Databricks Simba JDBC driver. You can download the driver on https://databricks.com/spark/jdbc-drivers-download?_ga=2.198791215.1433237262.1657645460-440078606.1...

If you still have problems, you can use the legacy spark driver as described here https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html#building-the-connection-url-for-the-le...