Excel Add-In for Snowflake

Build 26.0.9770

Authentication

このセクションでは、本プロバイダーの接続設定で設定可能なAuthentication プロパティの全リストを提供します。


プロパティ説明
AuthSchemeSnowflake への接続を確立するために使用する認証スキームを指定します。ユーザーのIDを検証するために必要な認証メカニズムを決定し、さまざまなSSOおよびOAuthプロバイダーとの統合を可能にします。
AccountThe Snowflake account identifier used to connect to a Snowflake instance. The account identifier is usually derived from the URL automatically.
WarehouseSpecifies 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.
UserSnowflake データベースへの認証に使用するユーザー名を指定します。
PasswordSpecifies the user's password used for authenticating with Snowflake. This property is required when using password-based authentication methods, including Password, PingFederate, and Okta.
WorkloadIdentityProviderSpecifies the cloud provider type for Workload Identity Federation authentication with Snowflake. This property is required when AuthScheme is set to WorkloadIdentityFederation.
URLSet 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.
WorkloadIdentityTokenSpecifies the OIDC identity token used for Workload Identity Federation authentication with Snowflake. This property is required only when WorkloadIdentityProvider is set to OIDC.
MFAPasscodeProvides 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.
RoleNameSpecifies 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.
AzureResourceAzure Managed Service Identity(MSI)、またはAzure 経由のWorkloadIdentityFederation を使用してSnowflake に対して認証する際に使用するEntra ID リソース識別子を指定します。

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770