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".
Super UserHello henrituol
Fabric mirroring currently lacks native Snowflake service principal integration.
Managed Identity (SAMI): Supported for Azure SQL mirroring but not available for Snowflake in Fabric.
as you have pointed out REST API seems to be only option which can be explored around
And it has support for SPN and MI's
Hope this helps.
Please accept the answer if this is helpful
- henrituol
Thanks! I'll check the REST API to see if I can establish a connection. However, I do hope Microsoft addresses this issue, because it seems that when MFA becomes mandatory, native integration will be needed.
- henrituol
Looks like the Microsoft Entra supported identities refer to using the REST API, not the actual underlying payload to create the connection. It seems that there's no way to make the connection with a service principal.
Also, if someone is interested, here's the announcement in snowflake.com: https://www.snowflake.com/en/blog/blocking-single-factor-password-authentification/