Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Microsoft Fabric mirrored databases from Snowflake

I need to get data from Snowflake through Microsoft Fabric's Mirroring feature. The following permissions are required for this to work:

  • CREATE STREAM
  • SELECT table
  • SHOW tables
  • DESCRIBE tables

However, when granting these permissions to the selected database, they are not being displayed. Is there a role or permission to perform this operation in Snowflake?

 

ref.: https://learn.microsoft.com/en-us/fabric/database/mirrored-database/snowflake-how-to-data-security#security-considerations

 

 

1 Reply