Specifies 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 .

Data Type

string

Default Value

""

Remarks

The contents of this property is dependent on the PrivateKeyType. This property's content can take one of three forms.

• The certificate store type is a file-based type, such as PEMKEY_FILE, PFXFILE, or PUBLIC_KEY_FILE: this property must be set to the path to the file.
• The certificate store type is a blob-based type, such as PEMKEY_BLOB, PFXBLOB, or PUBLIC_KEY_BLOB: this property must be set to the text content of the file.
• The certificate store type is a Windows-only type such as USER or MACHINE: this property refers to the certificate name.

If the certificate store is password protected, specify the password in PrivateKeyPassword.

Designations of certificate stores are platform-dependent.

The following are designations of the most common User and Machine certificate stores in Windows:

MY	A certificate store holding personal certificates with their associated private keys.
CA	Certifying authority certificates.
ROOT	Root certificates.
SPC	Software publisher certificates.

In Java, the certificate store normally is a file containing certificates and optional private keys.