Forum Discussion
Advocate IIMirroring Snowflake with a Managed Identity?
Unfortunately, this is still unresolved. I opened a support ticket with Microsoft and they are still "working with the Product Group regarding the authentication types supported in the future for snowflakes mirroring considering the MFA mandate".
Community SupportThank you, nilendraFabric , for your response.
Hi henrituol,
We appreciate your inquiry on the Microsoft Fabric Community Forum.
Thank you for highlighting the impact of Snowflake MFA on Fabric mirroring.
As mentioned in the document Limitations for Microsoft Fabric Mirrored Databases From Snowflake - Microsoft Fabric | Microsoft Learn, Fabric mirroring currently supports Snowflake connections mainly through username/password and Entra ID SSO.
If you have found any other solution, we would be grateful if you could share it with the community and mark it as the accepted solution. This will help others facing similar issues and benefit the community.
Thank you.
Advocate III suppose it is possible to use Microsoft Authentication after all. In Entra ID, you can exclude a user from MFA. Some organizations utilize Shared Accounts for services—these do not seem to be a proper service entity like a Service Principal or Managed Identity, but at least they are not tied to a single user. Snowflake receives tokens from Entra ID; therefore, I assume mandatory MFA won't affect this connection. As long as you have a corresponding user in Snowflake, you can set up a user with a restricted role that exposes the BI layer for Fabric.