Hello, everyone! I have a query about the JDBC configuration for Databricks in Azure. To reach the cloud, a range of IP addresses is being used: 11.12.13.0/25 And with this the /etc/hosts is configured: 11.12.13.0 adb-000111222333444555.666.azuredatabricks.net 11.12.13.1 adb-000111222333444555.666.azuredatabricks.net 11.12.13.2 adb-000111222333444555.666.azuredatabricks.net 11.12.13.3 adb-000111222333444555.666.azuredatabricks.net ... On the other hand, this is the SAS code defined to establish the connection: options sastrace = ',,,d' sastraceloc = saslog; %let drvrclss = com.databricks.client.jdbc.Driver; %let dtbrcks = adb-000111222333444555.666.azuredatabricks.net; %let prt = 443; %let pthw1 = sql/protocolv1/o/111222333555777/0123-98765-waged92; %let pthw2 = sql%2Fprotocolv1%2Fo%2F111222333555777%2F0123-98765-waged92; %let uid = token; %let pwd = dapi0a1b2c3d4e5f6g7h8i9j-0; %let clsspth = /opt/sas/client/azure_databricks/; libname dbricks jdbc driverclass = "&drvrclss" url = "jdbc:spark://&dtbrcks:&prt/default;transportMode=http;ssl=1;httpPath=&pthb1;AuthMech=3;UID=&uid;PWD=&pwd" classpath = "&clsspth" schema = "default" ; However, I get this error: ERROR: Error trying to establish connection: Could not open connection to jdbc:spark://adb-000111222333444555.666.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/111222333555777/0123-98765-waged92;AuthMech=3;UID=token;PWD=dapi0a1b2c3d4e5f6g7h8i9j-0. The JDBC connection string (URI) could not be handled by the driver. ERROR: Error in the LIBNAME statement. Is there something wrong with the libname configuration? PS: As classpath I consider the path where is in jar file SparkJDBC42.jar
... View more