Forum Discussion
Not able to update Datawarehouse Shortcut Table in Notebook
Hi All ,
I have created datawarehouse shortcut table in OneLake .When i m trying to update shortcut table in Notebook , getting below error.
" User is not authorized to perform current operation for workspace ".
I have the member access in fabric workpsace. Let me know how to update Shortcut tables in fabric 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.
6 Replies
- AndyDDC
Most Valuable Professional
Hi Anonymous @I'm just trying to work through your actions. Can you confirm if you are creating a shortcut in a lakehouse to another lakehouse table, or are you creating a shortcut in a lakehouse to a warehouse table?
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.
