Forum Discussion

AnmolGan81's avatar
AnmolGan81
Icon for Advocate II rankAdvocate II
1 year ago
Solved

How to establish connectivity between dedicated Synapse pool to Azure fabric warehouse?

I have been trying to establish connectivity between dedicated Synapse pool and Azure fabric warehouse, in order to move data across synapse analytics to fabric warehouse, but I am unable to do so us...
data engineering
data pipeline
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi AnmolGan81 ,To set up the service principal for connectivity between Synapse pool and Azure Fabric warehouse, ensure the following roles and permissions are assigned:

    • Admin or Member role in the Fabric workspace for full control access.
    • ADMINISTER DATABASE BULK OPERATIONS, INSERT, CREATE TABLE, and ALTER ON SCHEMA permissions for executing data movement commands.

       

      For detailed step-by-step guidelines, you can refer to the Access control in Synapse workspace how to - Azure Synapse Analytics 

       

       

       

      Thanks,

      Prashanth Are

      MS Fabric community support

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.


If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.