topic Re: Notebook execution failed at Notebook service with http status code - '200' in Data Engineering

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

aAmirkHan — Mon, 13 May 2024 04:30:15 GMT

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?

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

Anonymous — Mon, 13 May 2024 05:02:48 GMT

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-from-Pipeline/m-p/3756263#M5024

Hope this helps.

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

aAmirkHan — Mon, 13 May 2024 05:37:13 GMT

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