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"
Hi digitalbrain,
As frithjof_v mentioned, there is no direct way to connect your Warehouse to a notebook. Is it possilble that you create the table you need in the Warehouse in a Lakehouse first and then create a shortcut in your Warehouse to your Lakehouse? Then you have full control with a notebook over that table and still be able to access the data from the Warehouse.
It's not possible to create a shortcut in a Warehouse
There is an Idea for that:
Lakehouse shortcuts available in Warehouse also
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e5e4905c-7c7a-ee11-a81c-000d3adc66b1
You can use cross-database queries, though.
However it's not exactly the same (you can't use it in a Direct Lake semantic model, I think. Admittedly, I haven't tried.).
And it's exposed to the potential for SQL Analytics Endpoint sync delay.
My apologies, you are both correct frithjof_v digitalbrain. There are no shortcuts in Warehouse (yet).
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"
