Add private_key_passphrase kwargs to Connection.__init__

[yassun7010]

What is the current behavior?

I am trying to move from User/Pass to Key/Pair authentication.

Snowflake's Python connector does not have a field to enter a passphrase if the secret key is passed as a byte string.

The passphrase can be used by passing RSAPrivateKey in Connection's private_key.

snowflake_conn = snowflake.connector.connect(
    user=SNOWFLAKE_USER,
    account=SNOWFLAKE_ACCOUNT,
    warehouse=SNOWFLAKE_WAREHOUSE,
    database=SNOWFLAKE_DATABASE,
    schema=SNOWFLAKE_SCHEMA,
    private_key=load_der_private_key(
        data=base64.b64decode(PRIVATE_KEY),
        password=PRIVATE_KEY_PASSPHRASE.encode("UTF-8"),
    ),
)

What is the desired behavior?

I can use the private key by passing RSAPrivateKey in private_key though,
It would be convenient to pass it directly as an argument, like any other user/password.

How would this improve snowflake-connector-python?

add private_key_passphrase params to Connection.__init__

References and other background

• https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs#private_key_passphrase-1

No response

[sfc-gh-dszmolka]

hi.- thanks for raising this enhancement request and especially the PR for it. The team will review.