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 ,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