Forum Discussion
bennoss
2 years agoRegular Visitor
Lakehouse Schema Error
Hi all, I have a lakehouse in which I enabled the schema preview and in doing so I created a 'raw' schema to try and setup some medallion architecture, however when do my organisation I ended up...
FabianSchut
Solution Sage
2 years agoHi bennoss, could you first try to refresh the lakehouse and see if the tables appear then? If you see the schema you could delete the schema and all underlying items at once in the lakehouse viewer.
However, if that remains invisible, could you attach the lakehouse to the notebook you are using to exectute the sql script and try again with the lakehouse attached? This error was also mentioned here: https://community.fabric.microsoft.com/t5/Data-Engineering/Cannot-Cross-workspace-Spark-SQL-queries-in-Microsoft-Fabric/m-p/4169679#M4228 and was solved this way.