Forum Discussion
How to write/update in Data warehouse table using Notebook
Hi FabianSchut, I think frithjof_v is correct here. I just tried to create a shortcut in data warehouse and there was no option to create it. Then I created a table in data warehouse and also created its shortcut in the lakehouse. I can read the data, but when I tried to overwrite the tabe via notebook, it threw an error. It confirms I can't write into the datawarehouse using notebook (same way as lakehouse table).
"Operation failed: "Forbidden", 403, PUT"
Usually when this question comes up, people mention pyodbc or jdbc as ways to write to Warehouse from Notebook.
I haven't tried either of them myself, but I have read about others who have used these methods.
However my impression is that this is a "workaround". The Notebook is primarily meant to be used for the Lakehouse, and not really for the Warehouse. However Pyodbc or Jdbc may work and enable you to write to the Warehouse from a Notebook, but it has limited performance, is my impression based on what I've read other places. https://www.reddit.com/r/MicrosoftFabric/s/Z8LPqsbxeU
You can also vote for this Idea:
Write Data into Data Warehouse from Fabric Notebook
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ac5bdbd2-5afe-ee11-a73c-000d3a7c9aa4