This connector is not compatible with interactive authentication methods, such as multi-factor authentication (MFA) with Duo Push.
You can use Key-pair authentication for looker user authentication.
Supporting link: https://docs.snowflake.com/en/user-guide/key-pair-auth