We were able to achieve this using Databricks through ODBC. Also, there was hint from SAS TS that support to read Parquet files might be available from SAS 9.4M8. If it happens, hopefully we should be able to directly access Delta lake.
Steps,
1. Installed ODBC Driver Manager
2. Installed ODBC Driver for Databricks.
3. Added DSN information into odbc.ini
4. Added ODBCINI env variable into <sashome>/SASFoundation/9.4/bin/sasenv_local
5. Validated the connection using isql command.
6. Setup DB connectivity at SAS Metadata and other stuff and tested connectivity from SAS clients.
... View more