Hello
We have SAS Viya4 and Databricks both installed on AWS. We were able to connect to Databricks using Personal Access Token PAT.
But now the requirement is to connect using client-id and secret.
I have been able to do this in the windows environment without any issue.
Not able replicate this on Viya4 /Databricks on AWS.
Wondering if anybody can enlighten me on this on the modifications, I need to implement in the connection string,
The connection string in use for PAT is given below:
libname libdbrk SPARK platform=databricks
driverClass='cdata.jdbc.databricks.DatabricksDriver'
server="abcd-efgh.cloud.databricks.com" port=443
user=token pwd="xxxxxxxxxxxxxxxxxxxxxxxxxxxxx-x"
httpPath="/sql/1.0/warehouses/12346abcd"
properties='DefaultColumnSize=256;QueryPassthrough=true;Other=ConnectRetryWaitTime=300;Catalog=mycatalog;Database=myschema'
schema=myschema bulkload=no;
T