Azure synapse dedicated sql pool mirroring to share with external users

Hello Ratan,

Welcome to the Microsoft Q&A forum.

Are you looking to share a copy of the dedicated SQL pool database with external users? If so, you can't directly share a copy of a dedicated SQL pool with external users.

However, you can explore alternative methods:

• Create a pipeline to sync/copy data from one SQL pool to another SQL pool and provide access to external users by creating a new Active Directory group or adding external users to an existing group.

For more details on backup and restore operations for dedicated SQL pools, you can refer to the following documents:

https://video2.skills-academy.com/en-us/azure/synapse-analytics/sql-data-warehouse/backup-and-restore#restoring-from-restore-points

https://video2.skills-academy.com/en-us/azure/synapse-analytics/backuprestore/restore-sql-pool

https://video2.skills-academy.com/en-us/answers/questions/1140081/copy-data-from-synapse-dedicated-sql-pool-into-ano

I hope this answers your question. Please let me know if you have any further questions.