Forum Discussion

WDarwish's avatar
WDarwish
Frequent Visitor
2 years ago
Solved

Fabric Warehouse - Service Principal Connection

I want to build an application to write data into a Fabric Warehouse. This article says that there are 2 ways to connection to a Fabric Warehouse SQL Endpoint: https://learn.microsoft.com/en-us/fab...
data warehouse
WDarwish's avatar
WDarwish
Frequent Visitor
2 years ago

I actually created the principal as per this very same guide. I cannot get that principal to show up within Fabric WH when sharing or setting permissions.

  • WDarwish's avatar
    WDarwish
    Frequent Visitor
    2 years ago

    Great find! Exactly what I was after. Managed to authenticate using the principal and got things running. Thank you.

    • kjellvs's avatar
      kjellvs
      Icon for Helper I rankHelper I
      2 years ago

      I am trying to achieve the exact similar thing, however when authenticating with 

      ClientSecretCredential in python, I am unable to write to the warehouses. I am able to read from the same warehouses though.
       
      More specifically, I get the following Error:
      The INSERT permission or external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Rows/Insert' was denied on the object '[table]', database '[warehouse name]', schema 'dbo'.
       
      When using AzureCliCredential, this problem does not persist. 
       
      I have tried making the service principle admin (similar to my az credentials), but that also did not help.
       
      Any clue how to have the service principle write to the warehouse?
      kind regards,
      Kjell
      • AndyDDC's avatar
        AndyDDC
        Icon for Most Valuable Professional rankMost Valuable Professional
        2 years ago

        Hi kjellvs how are you trying to write to the Warehouse? If you are trying to write to the storage directly it won't work, inserts into the warehouse can only be done via the sql endpoint of the warehouse - just checking to see how you're inserting so please forgive me if you already know this