Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello, I'm currently working on the 'Get Started with Fabric' exercise, specifically in the 'Modify the pipeline' section of using Data Factory pipelines in Microsoft Fabric. After running the pipeline, I encountered an error with the notebook activities. Despite retrying the exercise, I consistently face the same error message:
Operation on target 'Load Sales notebook' failed: Notebook execution encountered an error at the Notebook service with HTTP status code - '200'. Please review the Run logs on the Notebook for additional details. Error 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.)
Thanks
Solved! Go to Solution.
Hi @Chelly
Thanks for using Fabric Community.
Can you please follow the below steps and retry :
At the leftside of the notebook please click on lakehouses.
Click on Add lakehouse.
Select the lakehouse where the table resides. Attach the lakehouse to the notebook.
Now try to run the pipeline. Please let me know if the issue still persists.
Hello
I encountered the same issue, and the solution that worked for me was to navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.
After doing this, the pipeline ran fine for me.
Hello
I encountered the same issue, and the solution that worked for me was to navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.
After doing this, the pipeline ran fine for me.
Hi @Chelly
Thanks for using Fabric Community.
Can you please follow the below steps and retry :
At the leftside of the notebook please click on lakehouses.
Click on Add lakehouse.
Select the lakehouse where the table resides. Attach the lakehouse to the notebook.
Now try to run the pipeline. Please let me know if the issue still persists.
I have the same problem but removing and adding the lakehouse doesn't solve it. It worked fine until recently, any suggestions on what I can try.
Hi @Chelly
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
5 | |
2 | |
2 | |
1 |
User | Count |
---|---|
16 | |
11 | |
7 | |
6 | |
6 |