SAS passthrough execution in Spark with JDBC or ODBC connection

[umeshMahajan]

Does SAS Support passthrough execution in spark using either JDBC or ODBC driver?

If I used JDBC or ODBC friver from SIMBA (https://www.simba.com/drivers/spark-jdbc-odbc/ ) can i do execution in spark and return result in sas as a sas dataset? is there SAS Access for spark available? or i have to use JDBC/ODBC drivers? and will it work?

[ChrisNZ · Accepted solution]

There is no reason ODBC should not be usable.

You should also be able to use pass-through.

libname SPARK odbc <connection parameters>;
proc sql;
  connect using SPARK;
  execute by SPARK ( pass-through code );
  select * from connection to SPARK ( pass-through query );
quit;