Getting error while running a pipeline

[jashfabric]

Hi,
I am new to Fabric and doing the exercise https://learn.microsoft.com/en-us/training/modules/use-data-factory-pipelines-fabric/.
Everything runs fine. But in the Modify Pipeline (https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/04-ingest-pipeline.html#modify-...) step I am facing an error:

Operation on target 'Sample 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.)

I have been trying to fix this from long but not able to succeed. Appreciate your help.

[Anonymous · Accepted solution]

Hi @jashfabric 
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. 

You can also try this:
Navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

Hope this helps. Please let me know if you have any further questions.

[Anonymous · Accepted solution]

Hi @jashfabric 
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. 

You can also try this:
Navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

Hope this helps. Please let me know if you have any further questions.

[jashfabric]

That helped a lot @Anonymous 
Thanks for the help.

[Anonymous · Accepted solution]

Hi @jashfabric 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.