Authentication
This section provides a complete list of the Authentication properties you can configure in the connection settings for this provider.
| Property | Description |
| AuthScheme | Specifies the authentication scheme used to establish a connection to Snowflake. It determines the authentication mechanism required for validating the user's identity and allows integration with various SSO and OAuth providers. |
| Account | The Snowflake account identifier used to connect to a Snowflake instance. The account identifier is usually derived from the URL automatically. |
| Warehouse | Specifies the name of the Snowflake warehouse to be used for query execution. A warehouse in Snowflake is a virtual compute resource that provides the necessary processing power to perform operations such as data loading, querying, and analytics. |
| User | Specifies the username used for authenticating with the Snowflake database. |
| Password | Specifies the user's password used for authenticating with Snowflake. This property is required when using password-based authentication methods, including Password, PingFederate, and Okta. |
| WorkloadIdentityProvider | Specifies the cloud provider type for Workload Identity Federation authentication with Snowflake. This property is required when AuthScheme is set to WorkloadIdentityFederation. |
| URL | Set this property to the URL of your Snowflake database instance. This URL is required for establishing a connection to your Snowflake environment and should follow the standard format provided by Snowflake. The URL is typically structured as follows: https://orgname-myaccount.snowflakecomputing.com. |
| WorkloadIdentityToken | Specifies the OIDC identity token used for Workload Identity Federation authentication with Snowflake. This property is required only when WorkloadIdentityProvider is set to OIDC. |
| MFAPasscode | Provides a Multi-Factor Authentication (MFA) code when connecting to Snowflake. This code is required when MFA is enabled for your Snowflake account and you are using time-based one-time passwords (TOTP) or push-based authentication methods. |
| RoleName | Specifies the role assigned to the Snowflake user during authentication. This property determines the access privileges and permissions the user has when executing queries and managing resources in Snowflake. |
| CredentialsLocation | Specifies the location of the settings file where credentials are stored for authenticating with Snowflake. This property allows users to provide a custom path to a credentials file or use the default location if not specified. Storing credentials in a file ensures that sensitive information can be securely managed outside of the connection string. |
| AzureResource | Specifies the Entra ID resource identifier used to authenticate with Snowflake when using Azure Managed Service Identity (MSI) or WorkloadIdentityFederation via Azure. |