Notebook execution failed at Notebook service with http status code - '200'

[aAmirkHan]

I follow the steps instructively mentioned in Microsoft Learn Lab " Ingest data with a pipeline in Microsoft Fabric".

However, I am still getting errors while following the same steps in "Modify the pipeline" in the lab. 

Notebook execution failed at Notebook service with HTTP status code - '200', please check the Run logs on Notebook, additional details - 'Error name - AnalysisException, Error value - org. apache. Hadoop.hive.ql.metadata.HiveException: MetaException(message: Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.)' 

Can you please help me with this and how to fix it?

 

[aAmirkHan]

Hi @Anonymous ,

Thank you for your quick response to my query. I have tried your suggestion, where I can see data in the lakehouse.

However, I am following up with Microsoft Lab "Use Data Factory pipelines in Microsoft Fabric".

I am in doubt at this stage and maybe I am getting errors due to these steps.

Can you please help what I should select in the base parameters?

Thank you once again

[Anonymous · Accepted solution]

Hi @aAmirkHan 

Thanks for using Fabric Community.

Can you please try to create a new notebook and then attach the lakehouse. Now try to run this notebook from the pipeline. If the issue still persists please do let me know. This way there wont be a grey out option and you can attach or detach the lakehouse.

Did you try to set the target lakehouse as the default lakehouse? Default lakehouse is identified by the pin icon.

You can refer to this link for more help

https://community.fabric.microsoft.com/t5/General-Discussion/Notebook-fails-with-error-200-when-run-...

Hope this helps.