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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.