Hello I executed the following code (solution from the forum post   Solved: PROC DATASETS "WARNING: No matching members in directory." - SAS Support Communities ) data _null_; set sashelp.vtable(where=(libname='LIBDBRK' and MEMTYPE='DATA')) nobs=obs; if (obs > 0) then rc = dosubl('proc datasets lib=libdbrk memtype=data kill NOLIST NOWARN;run;quit;'); run; and this gave the following log 80 data _null_; 81 set sashelp.vtable(where=(libname='LIBDBRK' and MEMTYPE='DATA')) nobs=obs; 82 if (obs > 0) then 83 rc = dosubl('proc datasets lib=libdbrk memtype=data kill NOLIST NOWARN;run;quit;'); 84 run; NOTE: There were 0 observations read from the data set SASHELP.VTABLE. WHERE (libname='LIBDBRK') and (MEMTYPE='DATA'); NOTE: DATA statement used (Total process time): real time 1.59 seconds cpu time 0.03 seconds 85 86 /* region: Generated postamble */ 87 /* Close ODS destinations */ 88 &graphterm; ;*';*";*/;run;quit; 89 quit;run; 90 ods html5 (id=web) close; 91 ods listing close; 92 %if %sysfunc(fileref(_gsfname)) lt 0 %then %do; 93 filename _gsfname clear; NOTE: Fileref _GSFNAME has been deassigned. 94 %end; 95 %studio_capture_custom_output; 96 /* endregion */ 97 Wondering if I need to make any changes to my libname statement as mentioned in the previous post? ... View more

Hello I have been able to successfully connect using the following code libname libdbrk jdbc preserve_tab_names=yes schema=catalog.schema class="cdata.jdbc.databricks.DatabricksDriver" URL="jdbc:databricks:Server=abcd-efgh.cloud.databricks.com:443;HTTPPath=/sql/1.0/warehouses/1234567890; Token=Personal_Access_token;" While the library is successfully created, cannot see any tables. I ran the proc datasets as follows proc datasets lib=libdbrk; run; The log has proc datasets lib=libdbrk; WARNING: Execute error: Directory Libref LIBDBRK Engine JDBC Physical Name jdbc:cdata:Databricks:Server=abcd-efgh.cloud.databricks.com:443 Schema catalog.schema WARNING: No matching members in directory. 81 run; Looking to the community for guidance. Thanks ... View more

Hello @Tom  Thanks. I have tried using driver_trace option. But I have the error as follows WARNING: Libref DBRK is not assigned. 27 option VALIDMEMNAME=EXTEND VALIDVARNAME=ANY; 28 libname dbrk odbc dsn="dbrk" user="client_id" password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 28 ! schema="catalog.schema" driver_trace=ALL; ____________ 22 ERROR: Libref DBRK is not assigned. ERROR: Error in the LIBNAME statement. ERROR 22-7: Invalid option name DRIVER_TRACE. Thanks once again ... View more

Thanks @ballardw  I am able to able to see the data from the table, but tables themselves are not visible in the library. Using VALIDMEMNAME=EXTEND and VALIDVARNAME=ANY did not help. One more observation I have. For the schema one has to use catalog_name.schema_name.  Using only the schema name seems to not work. I was able to run proc contents on the table, but data=libref._ALL_ did not show up any tables. Similarly proc datasets libref=library did not show any tables. ... View more

Thanks @gwootton . I appreciate your time and efforts in assisting me. I have already tried that. It does not work ... View more

Yes I am indeed able to connect from out  side SAS. ... View more

Thanks @gwootton . I removed the quotes, but the error remains the same. ... View more

Thanks. They are less than 32 characters. ... View more

Thanks @Tom . @MrSantos  I just ran a test using plain java code and was able to see the tables with the same credentials as I used with SAS. I changed the case of catalog name and yes it worked as before. So, it appears they appear to be case insensitive. ... View more

Thanks @Nigel_Pain . I appreciate your help. The result is the same. The log is here   NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 25 GOPTIONS ACCESSIBLE; 26 PROC SQL; 27 connect to odbc as dbrk (dsn="dbrk" user="client-id" 27 ! password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ); 28 select * from connection to dbrk ( 29 ODBC::SQLTables(,,,) 30 ); NOTE: No rows were selected. 31 disconnect from dbrk; 32 quit; ... View more

Yes. ... View more

Thanks @gwootton . I followed your suggestion and updated my code as follows libname libdbrk jdbc driver="/opt/sas/viya/home/lib64/accessclients/jdbc/cdata-jdbc-databricks-23.0.8806.0.jar" class="cdata.jdbc.databricks.DatabricksDriver" URL="jdbc:databricks:Server=xyz.databricks.com; HTTPPath=/sql/1.0/warehouses/abcdefgh; user='client-id';Token='Token'"; The log is ERROR: Error trying to establish connection: HTTP protocol error. 401 Unauthorized. ERROR: Error in the LIBNAME statement. It has no option for using the port (443). Using port=443 or protocol=https raises an error. Can you please advise. ... View more