We are using a Snowflake account without two-factor authentication (2FA) connected to Retool. However, due to changes in Snowflake's security policy, all accounts are now required to enable MFA or, for APIs, connect using key-pair authentication. Retool still connects using account-based authentication. How should we respond to this change?
1 Like
Hi @sangbom.ha
I'm setting up a brand new Retool Instance and Snowflake Instance, so I'm not sure if you can follow this exact procedure without disrupting your existing setup.
With that said, here is what I did...
First, I created a user of type=service.
This user type does not require that MFA is enabled.
I then created a key pair for that new user.
In Retool, when creating the Snowflake resource, I chose the Key Pair auth method.
Now I'm able to connect to from Retool to Snowflake.
Hope this helps!
1 Like