The SAS/ACCESS to Spark LIBNAME statement to Amazon Web Services (AWS) Databricks with OAuth 2.0 authentication (auth=oauth2) can fail with the following error message.
ERROR: No login information was available for authdomain @origin. The credentials for the user "xxxxxxxx" in the domain "xxxxxxxxx"
SAS/ACCESS to Spark supports only Personal Access Token (PAT) authentication to AWS Databricks. There is no native support for OAuth 2.0 or Single Sign-On (SSO) on AWS.
The Simba JDBC driver for Databricks, which is shipped with the SAS® Viya® platform, supports the Machine-to-Machine (M2M) authorization protocol to implement the OAuth 2.0 client grant flow. You might be able to specify the required driver-level options in the "Properties" or "URL" LIBNAME option to pass the needed authentication values. For more information, see the Using OAuth 2.0 section of the Simba JDBC Driver for Databricks documentation.
To configure OAuth 2.0 M2M-based authentication, set the following driver-level options in the SAS/ACCESS to Spark LIBNAME statement:
For example, choose the SAS/ACCESS to Spark LIBNAME statement that corresponds to your SAS Viya platform release.
%let MYDBRICKS=dbc-xxxxxxxx-1023.cloud.databricks.com;
%let MYHTTPPATH=/sql/1.0/warehouses/c250cfbb10xxxxxx;
%let MYCATALOG=samples;
%let MYSCHEMA=nyctaxi;
/* Use "URL" syntax in Viya Platform Stable 2025.03, Stable 2025.04, and LTS 2025.03 */
libname dbricks SPARK platform=databricks
driverClass='com.simba.databricks.jdbc.Driver'
url="jdbc:databricks://&MYDBRICKS:443/&MYSCHEMA;
transportMode=http;ssl=1;httppath=&MYHTTPPATH;
defaultStringColumnLength=255;useNativeQuery=1;TemporarilyUnavailableRetryTimeout=1800;
ConnCatalog=&MYCATALOG;ConnSchema=&MYSCHEMA;
OAuth2ClientId=5cc36cbe-136b-462b-bed4-xxxxxxxxxxxx;OAuth2Secret=secretxxxxxxxx;Auth_Flow=1;AuthMech=11"
schema=&MYSCHEMA
bulkload=no
character_multiplier=1
PRESERVE_TAB_NAMES=YES
;
/* Use the "Properties" option in Viya Platform Stable 2025.05 and later */
libname dbricks SPARK platform=databricks
server="&MYDBRICKS" port=443
httpPath="&MYHTTPPATH"
properties="defaultStringColumnLength=255;useNativeQuery=1;TemporarilyUnavailableRetryTimeout^
=1800;
ConnSchema=&MYSCHEMA;ConnCatalog=&MYCATALOG;
OAuth2ClientId=5cc36cbe-136b-462b-bed4-xxxxxxxxxxxx;OAuth2Secret=secretxxxxxxxx;Auth_Flow=1;AuthMech=11"
schema=&MYSCHEMA
bulkload=no
character_multiplier=1
PRESERVE_TAB_NAMES=YES
;
For more information, see Simba JDBC Driver for Databricks.