Forum Discussion

DennesTorres's avatar
DennesTorres
Icon for Power Participant rankPower Participant
2 years ago
Solved

Shortcut maintenance

Hi, I noticed the following situation:   Considering I have a shortcut in one lakehouse and an object built using this shortcut in another lakehouse or data warehouse (a view, for example).   ...
data engineering
data warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi DennesTorres ,

    I didnot find any challenge in dropping the view from lakehouse_D.


    lakehouse_A : Main Table
    lakehouse_B : Shortcut created from Main Table (present in lakehouse_A)

    lakehouse_C : Shortcut created from Shortcut Table (present in lakehouse_B)
    lakehouse_D : View created for Shortcut Table (present in lakehouse_C)


    Able to preview the view and everything works proper.

    Deleted Shortcut Table (present in lakehouse_b) and then drop the view (present in lakehouse_D) which got executed perfectly.

     

    Hope it is helpful.



Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DennesTorres ,

Thanks for using Fabric Community.

Can you please help me understand how you were able to land into this scenario?
I would like to know how you were accessing shortcut in one lakehouse from another lakehouse/warehouse.
Could you please share detail steps so that I can reproduce the issue at my end and can check with the team.