Support keypair authentication

[gnilrets]

Is your feature request related to a problem? Please describe.
We use MFA on all of our developer accounts and using Meltano with MFA just doesn't work due to all the MFA requests. Looks like Snowflake doesn't ask for MFA if a keypair is used. It would be great if this target supported keypair authentication.

Describe the solution you'd like
Optional support for keypair auth instead of password.

Describe alternatives you've considered
None.

[msardana94]

@gnilrets I have created a similar issue (referenced already) and was wondering if you will also be able to leverage authenticator functionality for your MFA use case as mentioned in this doc?

dbt-snowflake (if you are familiar with it) uses the same config for MFA use cases as well.

EDIT: Just saw you have opened #305 which is what I was mentioning.

[gnilrets]

I believe authenticator would work for caching MFA auth which would be great.

Keypair auth may require a additional parameters referencing the location of the private key file and password if exists. dbt-snowflake does this too.

[ashish-atidiv]

Hey
I need the key pair auth too for target-snowflake. What's the status of this request?

[gnilrets]

PR submitted, but not merged or even acknowledged. I think this repo has been abandoned.