Forum Discussion

henrituol's avatar
henrituol
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Mirroring Snowflake with a Managed Identity?

What are the options to authenticate into Snowflake when mirroring into Fabric? At the moment, the Fabric tutorials point to Snowflake Username & Password authentication. Also, "Entra (single sign on...
Mirrored Snowflake
  • henrituol's avatar
    henrituol
    1 year ago

    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".

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

Hello 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's avatar
henrituol
Icon for Advocate II rankAdvocate II
1 year ago

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.