Connection parameters

The following table describes the Snowflake connection parameters you can use in the connect() module method.

Parameter	Description
`Authentication`	Specifies the authentication type. The possible values are: `Basic` – (Default) Basic authentication. `OAuth` – OAuth 2.0 authentication. `KeyPair` – Key pair authentication.
`ClientId`	Specifies the client ID of the OAuth security integration. Applies to OAuth 2.0 authentication. For information on how to obtain a client ID, see Obtaining credentials for OAuth 2.0 authentication.
`ClientSecret`	Specifies the client secret of the OAuth security integration, used together with the client ID. Applies to OAuth 2.0 authentication. For information on how to obtain a client secret, see Obtaining credentials for OAuth 2.0 authentication.
`Database`	Specifies the database to connect to.
`Domain`	Specifies the hostname of the Snowflake instance.
`Passphrase`	Specifies the passphrase for the encrypted private key. Applies to key pair authentication. For information on how to obtain a passphrase, see Obtaining credentials for key pair authentication.
`Password`	Specifies the password of the user. Applies to basic authentication.
`PrivateKey`	Specifies the path to the private key file. Applies to key pair authentication. For information on how to obtain a private key, see Obtaining credentials for key pair authentication.
`RefreshToken`	Specifies the refresh token. Applies to OAuth 2.0 authentication. For information on how to obtain a refresh token, see Obtaining credentials for OAuth 2.0 authentication.
`Role`	Specifies the role of the database user.
`Schema`	Specifies the name of the database schema.
`UserId`	Specifies the name of the user. Applies to basic and key pair authentication.
`Warehouse`	Specifies the name of the warehouse.
Proxy parameters
`ProxyHostName`	Specifies the hostname or IP address of the proxy server.
`ProxyPort`	Specifies the proxy port.
`ProxyUserName`	Specifies the username for proxy authentication.
`ProxyPassword`	Specifies the password for proxy authentication.
Other parameters
`PoolId`	Specifies the ID of a connection pool to be used for a particular connection.
`DisablePooling`	Disables connection pooling for a particular connection. The possible values are `True` and `False`. The default value is `False`.

Request Support

Python Connectors Forum

Provide Feedback