Forum Discussion

kjellvs's avatar
kjellvs
Helper I
2 years ago
Solved

VSCode - Connecting to lakehouse and coding aid

When running simple code in VSCode using the Synapse-spark-kernel, i run into the following issue when trying to access data from a lakehouse table. The exact same code does work in the fabric enviro...
data engineering
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi kjellvs ,
    Apologies for the delay in response. This error is expected behavior with the existing version of Fabric lakehouse. I filed a bug for reading reference lakehouse in VS Code and the team is working on fixing the issue ASAP.
    We are reaching out to the internal team to get more information related to ETA and will get back to you as soon as we have an update.
    Stay tuned for more updates.
    Thanks.



  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi kjellvs ,
    I will update you once I receive the information from the internal team. You can go ahead and close the ticket.
    Thank you.

y0m0's avatar
y0m0
Frequent Visitor
2 years ago

I am not the OP but the issue is not solved yet.
Your suggested solution works if there is only 1 lakehouse reference in the notebook and if its marked as default.
Like OP described, in a notebook I am trying to query data from 2 different lakehouse within the same workspace.

For example I have this 2 lakehouse registered on my notebook in fabric.

This works as expected from the web editor.


the same is not working from VSCode.

  • kjellvs's avatar
    kjellvs
    Helper I
    2 years ago

    as mentioned by support; 

    "I will update you once I receive the information from the internal team. You can go ahead and close the ticket."