Support for MFA pascode

[skarpecki]

Issue description

Connecting to Snowflake with MFA triggers Duo Push which has to be accepted in application. It's inconvienet if there are multiple connections established, as for each one of them we need to accept connection in app. Is it possible to somehow pass the passcode to .NET connection?

Example code

We tried both PasscodeInPassword and Passcode properties as described for ODBC (https://docs.snowflake.com/en/user-guide/security-mfa.html#using-mfa-with-odbc), none of them worked.

var builder = new SnowflakeDbConnectionStringBuilder();
...
...
...
builder["passcodeInPassword"] = "on";

var builder = new SnowflakeDbConnectionStringBuilder();
...
...
...
builder["passcode"] = passcode;

Error log

N/A

Configuration

Driver version: 1.2.2

Dotnet framework and version: .net framework 4.8

Server version: E.g. 1.90.1

Client OS: Windows 10

[skarpecki]

Hello, is there any update regarding the issue?

[sfc-gh-dszmolka]

hi and thank you for raising this request. apologies for the long period without response. we'll track this request together with the SSO caching on #380