Fabric Snowflake Mirroring - Why are Tables Greyed Out?

[DarinSpence]

I'm using Fabric Snowflake Mirroring, and successfully connect to my database but noticed that the ability to select the tables is greyed out.  I suspect this may be something missing in the privledges or configuration of Snowflake.  Has anyone seen this behavior?  Any tips on where to look would be great.  

[v-kaiyue-msft]

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

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.

[DarinSpence]

@v-kaiyue-msft,

All 3 of these columns are being replicated.  The question is, why am I not able deselect tables I do not want?
Thanks,
-Darin

[v-kaiyue-msft]

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.