Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
DarinSpence
Helper II
Helper II

Fabric Snowflake Mirroring - Why are Tables Greyed Out?

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.  EagleDistNE_FabricSnowflakeMirrorGreyedOut.png

3 REPLIES 3
v-kaiyue-msft
Community Support
Community Support

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.

@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

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.