The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Also, a few connection string attributes do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.

Note: The driver does not support specifying values for the same connection option multiple times in a connection string or DSN. If a value is specified using the same attribute multiple times or using both long and short attributes, the connection may fail or the driver may not behave as intended.

The following tables list the connection string attributes supported by the Snowflake driver.

General options

The following table summarizes general connection options that can apply to all connections that use data sources.

Table 1. General options
Attribute (Short Name) Default
AccountName (an) No default value
DatabaseName (db) No default value
DataSourceName (dsn) No default value
Description (desc) No default value
RoleName (role) No default value
Schema (schm) No default value
Warehouse (wh) No default value

User ID and password authentication options

The following table summarizes options used for user ID and password authentication.

Table 2. User ID and password options
Attribute (Short Name) Default
AuthenticationMethod (am) 0 (UserIDPassword)
Password (pwd) No default value
User No default value

Browser-based SSO authentication options

The following table summarizes options used for browser-based SSO authentication.

Table 3. Browser-based SSO authentication options
Attribute (Short Name) Default
AuthenticationMethod (am) 0 (UserIDPassword)
User No default value

OAuth 2.0 options

The following table summarizes options used for OAuth 2.0 authentication.

Table 4. OAuth 2.0 options
Attribute (Short Name) Default
AccessToken (atok) No default value
AuthenticationMethod (am) 0 (UserIDPassword)
AuthURI (o2au) No default value
ClientID (cid) No default value
ClientSecret (clse) No default value
OAuthCode (oac) No default value
RedirectURI (o2ru) No default value
RefreshToken (rtok) No default value
Scope (oas) No default value
TokenURI (o2tu) No default value

Key-pair authentication options

The following table summarizes options used for key-pair authentication.

Table 5. Key-pair options
Attribute (Short Name) Default
AuthenticationMethod (am) 0 (UserIDPassword)
PrivateKeyContent (pkc) No default value
PrivateKeyFile (pkf) No default value
PrivateKeyPassphrase (pkpp) No default value
User No default value

Proxy server options

The following table summarizes proxy server options.

Table 6. Proxy server options
Attribute (Short Name) Default
ProxyHost (pxhn) No default value
ProxyPassword (pxpw) No default value
ProxyPort (pxpt) No default value
ProxyUser (pxun) No default value

SQL engine options

The following table summarizes SQL engine options.

Table 7. SQL engine attributes
Attribute (Short Name) Default
JVMArgs (jvma) For the 32-bit driver when the SQL Engine Mode is set to 2 (Direct):

-Xmx256m

For all other configurations:

-Xmx1024m
JVMClassPath (jvmcp) install_dir\java\lib\snowflake.jar
JVMPath (jvmp) install_dir\jre\bin\java.exe
ServerPortNumber (sport) For a 32-bit driver:

19948

For a 64-bit driver:

19947
SQLEngineMode (sem) For Windows: 0 (Auto)

For UNIX/Linux: 2 (Direct)
SQLService (ss) No default value

Timeout options

The following table summarizes timeout options.

Table 8. Timeout attributes
Attribute (Short Name) Default
LoginTimeout (lt) 60
QueryTimeout (qt) 0

Additional attributes

The following table summarizes additional attributes.

Table 9. Additional attributes
Attribute (Short Name) Default
ArrowFallbackToJson (aftj) 0 (Enable)
ClientSessionKeepAlive (cska) 0 (false)
DisableSocksProxy (dsp) 0 (false)
ExtendedOptions (xo) No default value
IntegerFieldMapping (ifm) 1 (Numeric)
LogConfigFile (lgcf) ddlogging.properties
PartnerApplicationName (pan) No default value
ReportCodepageConversionErrors (rcce) 0 (Ignore Errors)
UseSessionDatabaseForMetadata (usdm) 0 (false)