How to connect to a Snowflake with using a Service Type user?

Get Help
1

Hi,

I'd like to set up a Database log in to snowflake with a user whos user type is service and these users do not require a password. How can use this type of user? Snowflkake will enforce MFA log-in for all human users. How can metabase be connected to snowflake using a service user?

https://docs.snowflake.com/en/user-guide/admin-user-management#label-user-management-types

I'd appreciate your guidance!

2

I think we already addressed this on the latest verison

3

Hey @Luiggi Can you point to the specific Metabase version that addressed this? What changed—did it add support for key-pair authentication, OAuth, or another method? A link to the release notes would be helpful.

Need to ensure we’re ready before Snowflake enforces MFA in April 2025. Thanks!

4

Thanks Luiggi!

After upgrading to v0.52.13, there is an option in the database connection setting to use key-pair auth on Snowflake.