JDBC Driver for Snowflake

Build 24.0.9060

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.


PropertyDescription
AuthSchemeThe authentication scheme used. Accepted entries are Password, OKTA, PrivateKey, AzureAD, AzureMSI, OAuth, PingFederate, or ExternalBrowser.
AccountThe Account provided for authentication with Snowflake database. This is usually derived from the URL automatically.
WarehouseThe name of the Snowflake warehouse.
UserThe username provided for authentication with the Snowflake database.
PasswordThe user's password.
URLThe URL of Snowflake database.
MFAPasscodeSpecifies the passcode to use for multi-factor authentication.
RoleNameThe role of the Snowflake user: PUBLIC, SYSADMIN, or ACCOUNTADMIN.
CredentialsLocationThe location of the settings file where credentials are saved.
AzureResourceThe Azure Active resource to authenticate to (used during Azure Managed Service Identity exchange).It should be set to the App Id URI.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060