Excel Add-In for Snowflake

Build 26.0.9770

KeyPairAuth

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


PropertyDescription
PrivateKeySpecifies the private key used for Key Pair Authentication when connecting to Snowflake. This property allows authentication via a public-private key pair, providing a highly secure alternative to standard password-based authentication. The PrivateKeyType field specifies the type of the certificate store specified by PrivateKey .
PrivateKeyPasswordSpecifies the password used to decrypt the private key when using Key Pair Authentication with Snowflake. This property is required when the private key file is encrypted with a password for added security.
PrivateKeyTypeSpecifies the type of key store or format containing the private key used for Key Pair Authentication with Snowflake. This property allows the user to choose from various formats and storage mechanisms for supplying the private key.
PrivateKeySubjectSpecifies the subject name of the certificate containing the private key used for Key Pair Authentication with Snowflake. This property is necessary when the PrivateKeyType is set to USER or MACHINE, indicating that the private key is stored in a certificate store rather than a file or PEM blob.
JWTAlgorithmSpecifies the JWT signing algorithm used for Key Pair authentication with Snowflake. When left at its default, the provider automatically selects the algorithm based on the private key you supply.

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