Forum Discussion
Helper IIFabric Snowflake Mirroring - Why are Tables Greyed Out?
Hi DarinSpence ,
Only valid columns are replicated to Fabric OneLake. You can set security controls and policies from the SQL analytics endpoint. Each mirrored database has an automatically generated SQL analytics endpoint that provides a rich analytics experience on top of the delta tables created by the mirroring process. Users have access to familiar T-SQL commands that can define and query data objects, but cannot manipulate data from the SQL analytics endpoint as it is a read-only replica.
More details can be found in the documentation:
Microsoft Fabric mirrored databases from Snowflake (Preview) - Microsoft Fabric | Microsoft Learn
Better together - the lakehouse and warehouse - Microsoft Fabric | Microsoft Learn
Building Common Data Architectures with OneLake in Microsoft Fabric | Microsoft Fabric Blog | Microsoft Fabric
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIAnonymous,
All 3 of these columns are being replicated. The question is, why am I not able deselect tables I do not want?
Thanks,
-Darin
Hi DarinSpence ,
Make sure the user account used for mirroring has the necessary permissions in Snowflake. More details can be found in the documentation:
https://docs.snowflake.com/en/sql-reference/sql/create-stream.html#required-privileges
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.