Snowflake has announced the deprecation of username/password–based authentication as part of its security and MFA rollout, as described in the following blog: https://docs.snowflake.com/en/user-guide/security-mfa-rollout
As part of this change, Snowflake recommends using Key Pair authentication for service and application connections, as it provides stronger security. This authentication method is already supported in Power BI, but it is not currently available in Microsoft Sustainability Manager (MSM).
Adding support for Key Pair authentication in the Snowflake connector for MSM is critical for the following reasons:
- It significantly improves the security posture of MSM integrations with Snowflake.
- It ensures alignment with Snowflake’s supported authentication methods as password-based authentication is phased out.
- It prevents potential production outages or blocked integrations if username/password authentication is fully removed by Snowflake.
Without this capability, customers using MSM may face service disruption of their Snowflake integrations once password authentication is no longer supported.