OneLake shortcut to Lakehouse SQL endpoint fails to create table

[nbj-ksdh]

We have an Eventhouse database with a single table synced to OneLake. We've then created a table shortcut from the Eventhouse to a lakehouse - and everything works as expected: The table is visible in the lakehouse explorer, and can be queried using the SQL endpoint of the lakehouse. All good. 

A week later we then try to create another table shortcut from the eventhouse (same table) to a new lakehouse (in a different workspace). Now, the table is visible in the lakehouse explorer, but it fails to load the table to the SQL endpoint, giving the error in the image attached. The original (and completely similar) shortcut still works, and can be seen/queried in the SQL endpoint with data up to date. 

How can a shortcut work, and continue to work, when established at one point in time, but not a week later - when the source and destinations are structurally identical?

All workspaces are hosted in the same region (West Europe).

[Anonymous]

HI @nbj-ksdh,

Did these two workspaces host in the same data regions? Are there assign in the same environment and capacity?(trial or fabric capacity) Please share some more detail information to help us clarify your scenario and troubleshooting.

Regards,

Xiaoxin Sheng

[nbj-ksdh]

Hi @Anonymous , 
Everything is hosted on the same F16 Fabric capacity in West Europe. Even if i try to add a new lakehouse to the workspace where the shortcut works (in a different lakehouse), it will not work in the SQL endpoint, giving me the same error. Running OPTIMIZE on the table fails too.

Is there a way to run notebooks against the OneLake table created in the Eventhouse? Currently, pressing the notebook 'related item' in the Eventhouse doesn't do anything. 

[Anonymous]

Hi @nbj-ksdh,

So you mean this issue only appear when you work with lakehouse shortcut and the table create in eventhouse? Have you test to use shortcut from another source? I'd like to confirm if this is a specific source issue.

In addition, this issue sounds related to eventhouse, you can also try to post to the real-time intelligence forum to get better support.

Eventhouse and KQL - Microsoft Fabric Community

Regards,

Xiaoxin Sheng

[Anonymous]

HI @nbj-ksdh,

Any update on this? Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi  @nbj-ksdh 

Your question belongs to Data Engineering, I have transferred your question to the corresponding forum, an engineer will deal with you later, please be patient.

https://community.fabric.microsoft.com/t5/Data-Engineering/bd-p/ac_dataengineering 

Best Regards,
Community Support Team _ Ailsa Tao