'How to Connect with Dbeaver on Snowflake (DUO Push)
I am using Duo Mobile for authentication in snowflake . I have entered username and password and warehouse details in Dbeaver. But I keep getting error
"DUO PUSH IS NOT ENABLED FOR YOUR MFA. PROVIDE A PASSCODE AS PART OF THE CONNECTION STRING" .
I have tried to see https://community.snowflake.com/s/article/error-duo-push-is-not-enabled-for-your-mfa-provide-a-passcode-as-part-of-the-connection-string
here it says to add "passcodeInPassword=on".
Where do I need to add this?
Solution 1:[1]
I don't think we need to enable this parameter specifically for DUO to send the push notification. I tested this on DBeaver Community Version 21.2.2.202110030714 with a Snowflake user that is enabled for DUO and the connection (Test and Connect) works fine with the notification being received on the configured device.
Solution 2:[2]
You can right-click the Snowflake connection and hit 'Edit Connection' and then go to the 'Driver Properties' tab. Then, add the 'passcode' as a 'User Property' and put the actual passcode in the 'Value' field. Worked for me.
Solution 3:[3]
DBeaver might be using the JDBC driver to create a connection to Snowflake. You may need to pass it in the JDBC connection string at client (DBeaver) end. See- https://docs.snowflake.com/en/user-guide/security-mfa.html#using-mfa-with-jdbc
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Srinath Menon |
| Solution 2 | user19148239 |
| Solution 3 | Md Aurangzeb |