Forum Discussion

JOAOLBMARTINS's avatar
JOAOLBMARTINS
Icon for Helper II rankHelper II
2 years ago

MIRRORING SNOWFLAKE - Tables not shown on UI for specific Database/Schema

I'm not able to see tables that I have access on Snowflake on the Mirroring UI on Microsoft Fabric. I've already checked the permissions and I have all the ones required on the Database / Schema I'm...
Need Help
JOAOLBMARTINS's avatar
JOAOLBMARTINS
Icon for Helper II rankHelper II
2 years ago
For all having the same issue, looks like that the Snowflake Cloud source is not using the Role we pass to it when configuring the Cloud Connection. When using the mirroring feature, it was picking the default role and not the one defined on the connection itself. This seems to me to be a bug, once we have a field in which we speciafically pass the Role needed for that connection. A workaround was to define another role (with higher permissions) as being my Default role in Snowflake. By doing that, the permissions worked and the mirroing feature started to work. Thanks a lot, Best Regards,
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JOAOLBMARTINS 

     

    Glad to hear you solved the problem yourself! Could you please mark your solution as an ANSWER? This will help more users who are facing the same or similar difficulties. Thank you!

     

    Best Regards,
    Yulia Xu