SNOW-2884893: Intermittent error while using KeyPair Authentication in Net driver

[akshaybheda]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of .NET driver are you using?
   4.8.0

2. What operating system and processor architecture are you using?
   Windows 64 bit

3. What version of .NET framework are you using?
   E.g. .net 8.0

4. What did you do?

_connection = dbRetryPolicy.Execute(() =>
{
var connect = new SnowflakeDbConnection();
connect.ConnectionString = connectionString;
return connect;
});

_connection.Open();

5. What did you expect to see?

   I am getting following error
   Snowflake.Data.Client.SnowflakeDbException (0x80004005): Error: Required property PASSWORD is not provided. SqlState: , VendorCode: 270006, QueryId:
   at Snowflake.Data.Core.SFSessionProperties.CheckRequiredProperty(SFSessionProperty sessionProperty, SFSessionProperties properties)
   at Snowflake.Data.Core.SFSessionProperties.CheckSessionProperties(SFSessionProperties properties)
   at Snowflake.Data.Core.SFSessionProperties.ParseConnectionString(String connectionString, SessionPropertiesContext propertiesContext)
   at Snowflake.Data.Core.Session.SessionPool.GetSession(String connStr, SessionPropertiesContext sessionContext)
   at Snowflake.Data.Client.SnowflakeDbConnection.Open()

Its not consistent and happens intermittently, my initial thought was maybe i did wrong configuration for connection string but it works most of the time but randomly its throwing that exception.

6. Can you set logging to DEBUG and collect the logs?

I can try but its difficult, we host on azure web app instance and not on VM

[sfc-gh-dszmolka]

hi @akshaybheda , this will be fairly hard to troubleshoot from this error message alone, which only indicates that for that particular login attempt, the authenticator connection param was not provided (or was set to snowflake). Which implies password is a necessary property, which i guess is not present due to the keypair auth (as expected)

To move forward with this, could you please

• if its within your possibilities, try it out with the latest driver
• review the application code; is there anywhere a chance for authenticator connection configuration not to be populated ? (or set to anything else than SNOWFLAKE_JWT)
• if there's a minimal viable reproduction application which we can run on our side to reproduce the issue, it would be great if you could share
• the DEBUG logs will probably be needed; but without those if you have at least account/user name, timestamps, username; we can look up some things from server logs. Or the request_id (it's a uuidv4) for the particular login-request which failed, if you have it + Snowflake deployment.
  Please be advised maybe this only leads so far; confirming that for a particular login attempt no keypair authenticator was used (which we kinda already know, from the error message)

The last point might contain sensitive information which you might not want to share here publicly. If so, you can always work 1:1 with a Snowflake Support engineer if you submit this as a case (if you do so, please mention this GH issue).

Otherwise if you're ready to share information here , please make sure to sanitize it so no sensitive information is shared publicly.

Thank you in advance!

[akshaybheda]

I will update the package to latest meanwhile this is my connection string.

We only use 1 connection string and authenticator comes from that, so that will ruleout the issue about different config.

account=xxxx;host=xxxx.east-us-2.azure.snowflakecomputing.com;user=USERID;role=ROLE;db=DBNAME;schema=SCHEMANAME;Authenticator=SNOWFLAKE_JWT;Private_Key=-----BEGIN PRIVATE KEY-----PRIVATEKEY-----END PRIVATE KEY-----