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
AndyDDC
Most Valuable Professional
Most Valuable ProfessionalHi 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
kjellvs
Helper I
Helper IHi Andy, thank you for the reply. I was indeed trying to write via the SQL endpoint.
I found a fix by giving:
GRANT INSERT ON SCHEMA::dbo TO public;
I didn't know I had to configure these additional rights.
Kind regards,
Kjell