BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Stalk
Pyrite | Level 9

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

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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;

View solution in original post

3 REPLIES 3
Tom
Super User Tom
Super User

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
Pyrite | Level 9

How to get my class path?

SASKiwi
PROC Star

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 813 views
  • 3 likes
  • 3 in conversation