I have a Looker Studio connection to Snowflake using a Legacy Snowflake user -which allows entering with just a password. However, I understand that these user types will be migrated to service users and eventually forced to use MFA too.
But just wondering if this was something you are considering and/or aware of. Would really love continuing to use this connection on my reports! Thank you
SERVICE: For service-to-service authentication that uses programmatic access. This will be exempted from MFA enforcement, but those users will not support password authentication any more. Those users will support either OAuth or key-pair only.
I’m assuming you have your own Snowflake account that you use to log into the Snowflake web UI and this is the account you use for Looker. This will have to change, due to MFA, and you’ll need to get a separate SERVICE account for Looker.