Forum Discussion
Not able to update Datawarehouse Shortcut Table in Notebook
Hi Anonymous ,
If the shortcut is pointing to a Fabric Warehouse table, then you cannot perform a DML operation on the table using SPARK, the allowed operations is Read operation. If you want to perform an update/DML operation either use TSQL or use CTAS to save the resultset/table in the Lakehouse. Please refer to the below link for more detail on the allowed operations.
Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn
Hope this is helpful. Please let me know incase of further queries.
Hi Anonymous ,
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this as I can observe a similar issue.
We will update you once we hear back from them.
Anonymous Thanks
Hi Anonymous ,
If the shortcut is pointing to a Fabric Warehouse table, then you cannot perform a DML operation on the table using SPARK, the allowed operations is Read operation. If you want to perform an update/DML operation either use TSQL or use CTAS to save the resultset/table in the Lakehouse. Please refer to the below link for more detail on the allowed operations.
Fabric decision guide - choose a data store - Microsoft Fabric | Microsoft Learn
Hope this is helpful. Please let me know incase of further queries.