SNOW-1848370: Misleading error message when connection configuration is correct

[sfc-gh-twhite]

SnowCLI version

Snowflake CLI version: 3.0.1

Python version

Python 3.10.11

Platform

macOS-14.7-x86_64-i386-64bit

What happened

When executing snow snowpark build I'm receiving the following error (obfuscating account):

╭─ Error ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╮
│ Invalid connection configuration. 250001 (08001): None: Failed to connect to DB: xxx-xxx.snowflakecomputing.com:443. User is locked from Duo        │
│ Security. Contact your local system administrator.                                                                                                       │
╰──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╯

I know I have locked myself out of Duo and will wait fifteen minutes, but the message on this error is incorrect as this has nothing to do with connection configuration.

I'm not sure we can do much here as snowflake.connector.errors.DatabaseError 250001 (08001) seems to be more of a catch-all.

Console output

❯ snow snowpark build
Resolving dependencies from requirements.txt
╭─ Error ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╮
│ Invalid connection configuration. 250001 (08001): None: Failed to connect to DB: xxx-xxx.snowflakecomputing.com:443. User is locked from Duo        │
│ Security. Contact your local system administrator.                                                                                                       │
╰──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────╯

How to reproduce

MFA enabled on connection configuration where Duo locks out the user after Duo requests have expired without accepting the push.