Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Shortcut table not showing in SQL Endpoint nor Dataset

Hello.  I am able to successfully establish a shortcut from one lakehouse to another.  I am the owner of both and both exist in the same workspace (also owner there).     I can see the data in my l...
admin
data engineering
security
Ostrzak's avatar
Ostrzak
Icon for Helper II rankHelper II
2 years ago

Hi everyone,

The suggestion proposed by DennesTorres was interesting but unfortunately it is not the case. I have a delta table as a shortcut and sql queries don't work on it, although you can display it.

I'm not sure if it worked before Monday as FelixL mentioned. Would be great if it was fixed since the only solution I can think of would be to copy the file between the workspaces.

Thank you in advance for your help.


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

Hi,

I did shortcuts between delta tables in lake houses and datawarehouses with no problem, I even created a video, not published yet.

Your delta table may have something different/special to be failing. Try with a simple one between lakehouses for test purpose, then try to make them more similar as possible until you discover the difference which makes it fail.

Kind Regards,

 

Dennes