Not able to update Datawarehouse Shortcut Table in Notebook

[Anonymous]

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?

Upvote1Downvote0commentsShare

[Anonymous]

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]

@Anonymous  Thanks

[Anonymous · Accepted solution]

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]

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?

[Anonymous]

Hi @AndyDDC  I m creating Datawarehouse table shortcut in Lakehouse

[AndyDDC]

@Anonymous AFAIK Shortcuts are for reading data, you won't be able to modify data via a shortcut.