SAS Studio environment can use any JDBC data source thanks to its JDBC interface. On previous issues we have monitored a certain query modification done by the tool or the SAS/ACCESS interface resulting in badly formatted queries, throwing both server and driver errors.
On these occasions using the following code to connect and query enables a ‘’passthrough mode” which preserves the query from any modification done by SAS platform.
Example:
proc sql;
CONNECT TO JDBC as conn (classpath=“/Public/Drivers/cdata.jdbc.databricks.jar”
class=“cdata.jdbc.databricks.DatabricksDriver”
schema=<databricks_schema>
URL="jdbc:Databricks:Server=<your_server>;
HTTPPath=<yourhttppath>;
AuthScheme=PersonalAccessToken;Token=<your_token>");
Select * from connection to conn (Create table test1 (Name Varchar(10)));
disconnect from conn;
quit;
Additional details can be found on the following documentation: