Writeback to Fabric Lakehouse or Warehouse from external application

[VenDaFabricator]

We are working on use case where external application reads data from lakehouse using Service Principal credential and once it process the data need to write back with logs and results into fabric.  

For read, Service Principal was assigned with "Read all data using SQL (ReadData)" on Lakehouse.

To write back we got a Fabric Warehouse, how can i go assign Writer role to Service Principal so that they can write to warehouse.

Any clues, reference doc's would be great help.

[lbendlin · Accepted solution]

The SQL endpoint is read only.  To write into the warehouse you need to use user pocesses like pipelines, DF Gen2 etc.

What is data warehousing in Microsoft Fabric? - Microsoft Fabric | Microsoft Learn