Browser-based SSO authentication authenticates the user to the database using a web browser in Microsoft Windows. When using this method, the driver uses a web browser, ADFS, or any other SAML 2.0-compliant identify provider (IdP) when establishing a connection.

Important: Note that browser-based SSO is supported only when the SQL engine runs in direct mode or when the SQL engine server is launched from a command line. Browser-based SSO is not supported when running the SQL engine server as a Windows service.
To configure the driver to use browser-based SSO authentication:
  • Configure the minimum options required for a connection:
    • Set the Account Name (AccountName) to specify the name of your account and the region where it is hosted. For example, my_account.us-east-1.
    • Set the Database Name (DatabaseName) option to specify the name of database to which you want to connect.
    • Set the Warehouse (Warehouse) option to specify the name of the virtual warehouse to use, or an empty string.
    • Optionally, set the Schema (Schema) option to specify the schema to use for the specified database.
  • Set the Authentication Method (AuthenticationMethod) option to 45.
  • Set the User Name (User) option to specify your logon ID.
  • Optionally, specify values for any additional options you want to configure. See "Connection option descriptions" for a complete list of options.

The following examples demonstrate the connection information required to establish a session using user ID and password authentication.

Connection string

DRIVER=DataDirect 8.0 Snowflake;AccountName=MyAccountName.us-east-1;AuthenticationMethod=45;
       DatabaseName=MyDB;Schema=MySchema;Warehouse=MyWH;User=JohnQPublic;

odbc.ini file (32-bit driver)

Driver=ODBCHOME/lib/ivsnowflake28.so
Description=My Snowflake Data Source
...
AccountName=MyAccountName.us-east-1
...
AuthenticationMethod=45
...
DatabaseName=MyDB
...
Schema=MySchema
...
User=JohnQPublic
...
Warehouse=MyWH
...