Connect to Snowflake using MFA enrolled account

Hi all,
I connected Metabase to Snowflake with an account that enrolled MFA in Snowflake.
However, every time we run the query in the dashboards, I'm notified to authorize the request.
I don't find it's handy.

Here are my questions

  1. I'm thinking to connect to Snowflake using non-person account that is not required to enrol with MFA. Is it possible to connect to Snowflake with "service" account, which use key pair instead of password?
  2. Is there any way to eliminate the MFA prompt when we run queries or dashboards in Metabase?
  3. Does anybody have any better idea to solve this issue?

Thank you

Disabling MFA on user/pass is a configuration in Snowflake.

And yes, you can authenticate using key pair. In this UI there is RSA private key field.

Hi @arakaki ,

Thanks for getting back to me. I have attempted to use private key but I did not succeed yet.

  1. I used the uploaded rsa_key.p8 but it said Cannot open as a Reader

  2. I used the file path but it said File path for RSA private key (PKCS#8/.p8) points to non-existent file: /Users/studytube/rsa_key.p8

I checked the discussion here but it seems that Authenticating with Snowflake using private key is not available yet. Did I misunderstand something?

Do you have any other ideas to connect with Snowflake?

Thank you