The error occurs because passkey-based MFA, such as fingerprint or Face ID, is only supported for browser-based login, not for programmatic access. As you rightly mentioned, you can use key-pair authentication. Additionally, you can use a Programmatic access token (PAT) and a DUO MFA method, where you receive a push notification on your mobile device to log in to Snowflake. However, for DUO MFA, it is less ideal for automation as it still requires some user interaction.