Snowflake MFA token caching support?

5

@mike, I was able to make the MFA token caching work with the following steps:

  1. Update the ODBC driver to the latest version (Snowflake docs state that the minimum required version is 2.23.0).

  2. Allow MFA token caching by running the following command in the Snowflake console:

ALTER ACCOUNT SET ALLOW_CLIENT_MFA_CACHING = TRUE;

  1. In the DSN settings, set the Authenticator to username_password_mfa:

image
image410×569 32.6 KB

  1. In the EasyMorph connector settings set Authentication to User name and password and provide the correct user name and password.
Snowflake MFA not saving tokens