Connecting to Databricks from SAS Viya4 using Client-ID and secret

thesasuser — Fri, 24 Oct 2025 20:32:22 GMT

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;

Re: Connecting to Databricks from SAS Viya4 using Client-ID and secret

Sajid01 — Tue, 28 Oct 2025 00:51:49 GMT

As per this
"The PAT (Personal Access Token) Option must be enabled at Databricks Workspace for PAT, SSO, and Service Principal (SP) based access path to work. The user processes connecting to Azure Databricks with SSO or SP authentication using the JDBC driver initiate a PAT token at Databricks instance, even though it’s the SSO or SP based connection."
Though this is specifically for the case of Azure Databricks see if it applies to AWS

topic Re: Connecting to Databricks from SAS Viya4 using Client-ID and secret in Administration and Deployment

Connecting to Databricks from SAS Viya4 using Client-ID and secret

Re: Connecting to Databricks from SAS Viya4 using Client-ID and secret