Forum Discussion
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...
Maybe this blog will help?
How to use service principal authentication to access Microsoft Fabric's OneLake - Sam Debruyn
Great find! Exactly what I was after. Managed to authenticate using the principal and got things running. Thank you.
kjellvs
Helper I
Helper II 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'.
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