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...
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.
AndyDDC
Most Valuable Professional
Most Valuable ProfessionalHi 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?