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

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

Am exploring on the above, please allow me sometime.

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

Thanks for the confirmation, did you get a chance to look at this? i request you to update workaroud you have followed and accept as answer if you have any progress on mentioned issue that your facing to help others in the community and find answers easily.

 

 

 

Thanks,

Prashanth Are

MS Fabric community support