How to read databricks table that is greater than 32 character long?

[Stalk]

My ODBC connection to Simba Spark ODBC 64 bit is working fine and reading all the tables except 2 tables where the table names are greater than 32 character long.  previously I used SQL pass thru for SL server but not sure how to handle this in databricks

Thank you for your help

[Tom · Accepted solution]

You should be able to handle exactly the same way.

libname db odbc ..... ;
proc sql ;
  connect using db;
  create table want as select * from connection to db
  (select * from table_with_insanely_long_name_that_you_need_to_read)
  ;
quit;

[Stalk]

How to get my class path?

[SASKiwi]

AFAIK, CLASSPATH isn't an ODBC LIBNAME option. Please post your current ODBC connection statement.