Cannot Cross-workspace Spark SQL queries in Microsoft Fabric

[kurnivannoery]

I encountered the error [REQUIRES_SINGLE_PART_NAMESPACE] while trying to perform cross-workspace Spark SQL queries in Microsoft Fabric. The error states that 'spark_catalog requires a single-part namespace,' but I received 'Workspace.Lakehouse.dbo.' Do you have any solutions?

[FabianSchut]

Hi @kurnivannoery,

Did you enable schemas in both lakehouses? This is necessary to achieve this result: "Make sure you join tables only from lakehouses that have schemas enabled. Joining tables from lakehouses that don’t have schemas enabled won’t work.".

What is the complete query you are using?

[kurnivannoery · Accepted solution]

this issue is solved by adding lakehouse in notebook, if you didn't add lakehouse you can query lakehouse data.

[v-jingzhan-msft]

Hi @kurnivannoery 

Glad that you have solved it! Do you mean choosing a default Lakehouse for your notebook? Can you share the final query statement that works? This would help people who may encounter similar errors. 

Update:

I made a test. When selecting the lakehouse as the default lakehouse of the notebook, the query works without error. 

Best Regards,
Jing

Community Support Team