Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
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.
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.
User | Count |
---|---|
45 | |
25 | |
21 | |
18 | |
18 |
User | Count |
---|---|
51 | |
45 | |
24 | |
24 | |
21 |