BookmarkSubscribeRSS Feed
thesasuser
Lapis Lazuli | Level 10

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

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 65 views
  • 0 likes
  • 1 in conversation