FireDAC Components for Snowflake

Build 21.0.7958

AuthScheme

The authentication scheme used. Accepted entries are Password, OKTA, PrivateKey, AzureAD, OAuth, or PingFederate.

Syntax


property AuthScheme: String;

Possible Values

Password, OKTA, PrivateKey, AzureAD, OAuth, PingFederate

Data Type

String

Default Value

"Password"

Remarks

The component supports the following authentication mechanisms. See the Getting Started chapter for authentication guides.

  • Password: Set this to authenticate with a Snowflake user.
  • OKTA: Set this to use the OKTA SSO identity provider. Set SSOProperties in addition to the User and Password you use to authenticate to OKTA.
  • AzureAD: Set this along with User to use the Azure Active Directory identity provider. When connecting, your browser will open allowing you to login to Azure AD to complete the authentication.
  • PingFederate: Set this along with User to use the PingFederate SSO identity provider. When connecting, your browser will open allowing you to login to PingFederate to complete the authentication.
  • PrivateKey: Set this to use key pair authentication. Set PrivateKey, PrivateKeyPassword and PrivateKeyType in addition to authenticate with key pair authentication.
  • OAuth: Set this to use oauth authentication. Set OAuthClientId, OAuthClientSecret to the Snowflake OAuth credentials. Additionally, set InitiateOAuth to GETANDREFRESH. Note that the CData driver always uses PKCE with OAuth for extra security.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7958