Forum Discussion

Luigia-Costabil's avatar
Luigia-Costabil
Icon for Advocate I rankAdvocate I
3 months ago
Solved

How does the shortcut handle deletions?

If a record is deleted in a shortcut table, is the information that the record was deleted lost? In particular, I am referring to shortcuts used to connect Fabric to Dataverse. Thank you!
data engineering
lakehouse
  • deborshi_nag's avatar
    deborshi_nag
    3 months ago

    Hello Luigia-Costabil 

     

    Dataverse shortcuts are read-only. If a record gets deleted from the source, the shortcut will reflect the deletion and the row will not be returned in Lakehouse (in near-real time) .  

Lodha_Jaydeep's avatar
Lodha_Jaydeep
Icon for Solution Sage rankSolution Sage
3 months ago

Hi Luigia-Costabil,

 

You can't delete the records  from the shortcut as we can do for the local table (If you have write permission and you perforn delete operation data will be lost from the source itself). It's readonly for migrate data across diffrent lakehouses without copy.

It's just pointer from the source (Dataverse or OneLake), as per your case you can directly create the table shortcut in any lakehosue by use the Dataverse as a source.

For more guidance you can refer
https://community.fabric.microsoft.com/t5/Fabric-platform/Can-you-please-help-me-better-understand-quot-Shortcuts-quot/m-p/3666585 


Hope this helps, Please consider as accepeted solution if helps or give some kudos.