topic Re: How to read databricks table that is greater than 32 character long? in SAS Programming

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

Stalk — Mon, 11 Dec 2023 14:32:29 GMT

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

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

Tom — Mon, 11 Dec 2023 16:47:23 GMT

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;

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

Stalk — Mon, 11 Dec 2023 20:32:24 GMT

How to get my class path?

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

SASKiwi — Mon, 11 Dec 2023 21:05:05 GMT

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