Unable to Insert into Shortcut Table in Fabric

[abigailpham]

Hi there, I have recently been experiencing a problem where I can read data from a Shortcut (that links to a data warehouse) in my lakehouse notebook, but I cannot write data to it or delete data. I have confirmed that my permissions in the lakehouse/shortcut and the target data warehouse location are Admin. I have also confirmed matching schemas for the table in the shortcut and the data I am trying to insert.

I get this error: 
Caused by: java.nio.file.AccessDeniedException: Operation failed: "Forbidden", 403, PUT, ... Forbidden, "User is not authorized to perform current operation for workspace ____ and artifact ___"

Any help would be much appreciated. Thank you!

[AndyDDC]

Hi @abigailpham how are you writing/deleting data from the warehouse table? Can you share the process/code

[abigailpham]

Hi,

So in the lakehouse attached to this notebook I have created a shortcut to the warehouse I want to write to. The shortcut is "gold_movie_catalog_1".

My code:

# Insert into Shortcut

spark.sql("INSERT INTO MovieProduction.gold_movie_catalog_1 VALUES ('Test','Test','Test','Test','Test','Test','Test','Test');")

[v-cboorla-msft]

Hi @abigailpham 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing here.

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks

[v-cboorla-msft]

Hi @abigailpham 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks

[AndyDDC · Accepted solution]

Shortcuts to Warehouses are read-only, you won't be able to write/modify data in a Warehouse using a shortcut.  Infact you wont' be able to modify data in a Warehouse using a Notebook unless you use a JDBC driver, the Warehouse is a SQL-based service

[abigailpham]

Interesting! I think I got the wrong impression from the documentation that any shortcuts are read and write. We are going to solely use a lakehouse instead. Thank you for your response.