I also faced similar issue.

• I have resolved it by using the "Account Identifier" provided in snowflake account details sections.

• The Account Identifier will look something like: "XXXYYYY-XX12345"

It's the issue in metabase documentations, they are asking for the account name which is creating confusion while adding the snowflake database.

I also have implemented the Private Key authentications rather than using user name and password. Let me know if you need details about the Private Key authentications, will share same.