Connecting SAS to Snowflake via ODBC using SSO from external browser

PooryaShidfar — Mon, 26 May 2025 06:28:33 GMT

I am trying to use SAS ODBC to connect to my company's Snowflake account using SSO via an external browser. I was able to connect it with a macro and the User / Password as seen below:

%macro libname_snowflake(
connName /* Choose the local DB name */
,schema /* Choose the Oracle-like schema (owner) name */
);

/* This should minimize code rewrites with schema alias. */

%if &schema. = CS %then %do;
%let db=PUB_DATA;
%end;

* This presumes all schemas will begin with string PUB */

%else %if %substr(&schema., 1, 3) = PUB %then %do;
%let db=&schema.;
%end;

libname &connName. SNOW server="<MyCompany>.snowflakecomputing.com"

user=MyUserName
pw="***************************"
DATABASE=&db.
warehouse=REPORTING
schema=DATA_VENDING
role=MyRole
readbuff=1024
insertbuff=1024
dbcommit=0
TRACE=YES
SQLGENERATION=DBMS
conopts='sslmode=required'

;

%mend libname_snowflake;

I have seen on the web and the SAS support communities where I can modify the authentication segment to use the SSO with an external browser like below:

CONOPTS=('authenticator=EXTERNALBROWSER', 'URL=<your_sso_url>')

Has anyone successfully implemented this in SAS 9.4 X64 WIND PRO platform? Please, point me in the right direction. Thanks for the support.

topic Connecting SAS to Snowflake via ODBC using SSO from external browser in SAS Data Management

Connecting SAS to Snowflake via ODBC using SSO from external browser