Hi
I'm not sure if Databricks driver has been changed but when tested I got error when trying to list files from the first code. I'm using JDBC42-2.6.32 driver.
The working CASLIB statement in my case is as follows:
CASLIB dbspark dataSource=(srctype='spark', url="jdbc:databricks://ServerHostname:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/8982188031797693/0201-012252-gaq83b6a;AuthMech=3;UID=token;PWD=AccessToken", driverclass="com.databricks.client.jdbc.Driver", classpath="/data-drivers/jdbc/databricks",BULKLOAD=NO,schema="default" );
Regards
Zbyszek
... View more