Mirroring Snowflake

[mshilendhari]

Hi,

I am trying to mirror snowflake in MS fabtic and i get this error. There is no description on the error, it says internal error occured. I am able to see data in Snowflake but not in the SQL Server endpoint. Has anyone faced this issue?

[Anonymous]

Hi @mshilendhari 

• Check connectivity and permissions to ensure that the account used for the operation has the necessary permissions on both ends
• Check the mirroring settings in Microsoft Fabric to ensure that all settings are correctly applied
• This may be related to configuring Single Sign-On (SSO) for these data sources through an on-premise data gateway Snowflake supports Microsoft Entra ID for SSO, while SQL Server uses Kerberos. It is possible that SQL Server's SSO configuration is not set correctly. For more details, you can read related document link: Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mshilendhari · Accepted solution]

Hi Yulia,

The issue is fixed. It turns out that the service account i was using did not have stream access in Snowflake on the table i was trying to mirror. I tried on a table which had stream access and mirroring worked without any issue.