Forum Discussion
Read from a specified table from lakehouse in One workspace using Notebook in other workspace.
Hi Shanthan118 ,
Thanks for the reply from charlyS .
From the screenshot, it looks like you are experiencing a table not found error. Please double check that the table you are trying to read exists.
I tested it by creating a workspace called FabricTest1 and creating a new notebook in it that references the ProductsTest table from the daisyTest2 lakehouse in the daisyTest1 workspace. Load the data using Spark and you will see that everything works fine.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Most Valuable ProfessionalHello,
Looks like you are trying to access a table from a workspace that is not in the same workspace of the default lakehouse attached to the notebook.
For exemple here :
I'm querying a table from ConceptLkh but my notebook is pinned to the AmazingZoneLkh one, and it's not possible for now.
If you want to access data from another workpace as of today you can :
- Add a shortcut to the second Workspace in the default Lakehouse
- Query the data using the ABFS Path instead of the table name :
(in my exemple)