> For the complete documentation index, see [llms.txt](https://docs.appstrategy.com/apprules-r-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.appstrategy.com/apprules-r-documentation/platform/platform-features/system-settings/data-sources/connection-settings/data-warehouse/snowflake.md). # 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: * Azure: 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 --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.appstrategy.com/apprules-r-documentation/platform/platform-features/system-settings/data-sources/connection-settings/data-warehouse/snowflake.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.