Authentication
このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。
| プロパティ | 説明 |
| AuthScheme | Snowflake への接続を確立するために使用する認証スキームを指定します。ユーザーのIDを検証するために必要な認証メカニズムを決定し、さまざまなSSOおよびOAuthプロバイダーとの統合を可能にします。 |
| 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 | Snowflake データベースへの認証に使用するユーザー名を指定します。使用している認証方法（Password、OKTA、PrivateKey、または OAuth）に関わらず、接続を正常に確立するためにユーザー名が必要です。 |
| 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 | Azure Managed Service Identity（MSI） Authscheme 、またはWorkloadIdentityFederation Authscheme （ WorkloadIdentityProvider をAZUREに設定）を使用して認証する際に使用するEntra ID リソース識別子を指定します。Azure VM またはアプリケーションがSnowflake へのアクセスにAzure MSI またはAzure Managed Identity を使用するよう設定されている場合に必要です。 |