This error looks to me like it can't find the JDBC driver.
I've never tried this myself so can't really be of further help. If you don't get sufficient answers here in the forum then contact SAS TechSupport directly.
Below what Copilot suggested - which might or might not be correct.
To connect SAS to Databricks on AWS using the LIBNAME statement, you can use the JDBC interface. Here’s an example of how you might set this up:
libname mydblib jdbc
classpath="/path/to/jdbc/driver"
class="cdata.jdbc.databricks.DatabricksDriver"
URL="jdbc:databricks://<hostname>:443;httpPath='/sql/1.0/warehouses/<warehouse_id>';ssl=1;AuthMech=3;UID=<your_username>;PWD=<your_password>";
Replace the placeholders with your actual Databricks server details:
<hostname> : Your Databricks server name.
<warehouse_id> : The ID of your Databricks SQL warehouse.
<your_username> : Your Databricks username.
<your_password> : Your Databricks password.
Make sure the JDBC driver is correctly installed and the classpath points to the location of the driver.
If you encounter any issues, double-check the connection properties and ensure they are correctly formatted. For example, the httpPath should not have single quotes around it, and ssl should be set to 1 if using SSL.
Establishing a libname connection to Databricks from SAS Viya 4 on AWS
How to Speed Up Data Flow Between Databricks and SAS
... View more