Snowflake
Connecting to Snowflake
In addition to providing authentication (see below) set the following properties to connect to a Snowflake database:
Url: Both AWS and Azure instances are supported. For example:
AWS: https://myaccount.region.snowflakecomputing.com
Azure: https://myaccount.region.azure.snowflakecomputing.com
Account is only required if your Url does not conform to the usual syntax containing the account name at the beginning. Snowflake provides the Account name needed in this case.
Authenticating to Snowflake
The provider supports Snowflake via the Snowflake REST SQL API. Supports Basic authentication (username + password via classic endpoint) and JWT authentication (RSA key pair via SQL API v2). Exposes databases, schemas, and tables as queryable objects with full CRUD support.
Connection Properties
Property
Key (conn string)
Required?
Description
Account
Account
Yes
Snowflake account identifier, e.g. xy12345.us-east-1 (host prefix without .snowflakecomputing.com).
User
User
Yes
Snowflake username.
Password
UserPassword
Yes*
Snowflake password. *Required for Basic auth. Use UserPassword (not Password) to avoid DbConnectionStringBuilder stripping.
Database
Database
No
Default database context for queries.
Schema
Schema
No
Default schema within the database (default: PUBLIC).
Warehouse
Warehouse
No
Virtual warehouse to use for query execution.
Role
Role
No
Snowflake role to assume after login.
Auth Scheme
AuthScheme
No
Basic (default, uses classic endpoint) or JWT (uses SQL API v2 with RSA key pair).
Private Key File
PrivateKeyFile
No
Path to the RSA private key file (.p8 / PEM). Required for AuthScheme=JWT.
Private Key Pass
PrivateKeyPass
No
Passphrase for the encrypted private key file.
Timeout
Timeout
No
Request timeout in seconds (default: 60).
SSL Server Cert
SSLServerCert
No
* to accept all SSL certificates, or a specific certificate thumbprint.
Firewall Type
FirewallType
No
NONE (default), TUNNEL, SOCKS4, SOCKS5, HTTP.
Firewall Server
FirewallServer
No
Hostname or IP of the firewall/SOCKS proxy.
Firewall Port
FirewallPort
No
TCP port of the firewall/SOCKS proxy.
Firewall User
FirewallUser
No
Username for firewall authentication.
Firewall Password
FirewallPassword
No
Password for firewall authentication.
Proxy Auto Detect
ProxyAutoDetect
No
Auto-detect system proxy settings (default: true). Set false to specify manual proxy.
Proxy Server
ProxyServer
No
Hostname or IP of the HTTP/HTTPS proxy server.
Proxy Port
ProxyPort
No
TCP port of the proxy server.
Proxy Auth Scheme
ProxyAuthScheme
No
Proxy auth scheme: BASIC (default), DIGEST, NEGOTIATE, NTLM.
Proxy User
ProxyUser
No
Username for authenticated proxy.
Proxy Password
ProxyPassword
No
Password for authenticated proxy.
Proxy Exceptions
ProxyExceptions
No
Semicolon-separated host list that bypasses the proxy.
Log File
LogFile
No
Full path to the connector debug log.
Log Level
LogLevel
No
0 = disabled (default), 1 = write to log file.
Minimum Connection Strings
Username + Password (Basic Auth)
Account=xy12345.us-east-1;User=myuser;UserPassword=MyPass;Database=MYDB;Warehouse=COMPUTE_WH
RSA Key Pair (JWT Auth)
Account=xy12345.us-east-1;User=myuser;AuthScheme=JWT;PrivateKeyFile=C:\keys\rsa_key.p8;Database=MYDB;Warehouse=COMPUTE_WH
Last updated