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

Hi @AnmolGan81,

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue got resolved? or let us know if you need any further assistance here?

 

 

 

 

Thanks,

Prashanth Are

MS Fabric community support