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.


  • FelixL's avatar
    FelixL
    Icon for Advocate II rankAdvocate II
    2 years ago

    I have reproduced this issue in multiple capacities and multiple lakehouses. Whenever the original source (Lakehouse #1) of the delta table is external (in your case a lakehouse generated by Dataverse/Synapse. Link, in my case external Delta tables on ADLS Gen 2) the tables are missing in the SQL endpoint in Lakehouse #2, #3, ...

     

    I have also seen that the spark tables in Lakehouse #2, #3, ... are are experiencing issues if you link more than a few to the same Lakehouse. They start moving between "tables" and "unidentified" in the target Lakehouse randomly; forcing you to frequently refresh the tables in order to be able to query them. This also only seem to be the case when the source table is external (not managed in Fabric). 

     

    Both my issues has been forwarded to a developer/product team for further investigation. I will keep you posted here if/when I hear more. 

  • 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