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
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;
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;
How to get my class path?
AFAIK, CLASSPATH isn't an ODBC LIBNAME option. Please post your current ODBC connection statement.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.