To configure the driver to use user ID and password 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 0 (user ID and password), which is the default.
  • Set the User Name (User) option to specify your logon ID.
  • Set the Password (Password) option to specify your password.
  • 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;DatabaseName=MyDB;
       Schema=MySchema;Warehouse=MyWH;User=JohnQPublic;Password=SECRET

odbc.ini file (32-bit driver)

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