Problems with this exercise: Ingest data with a pipeline

Richard Hernandez 20 Reputation points
2024-04-24T04:11:05.0766667+00:00

I have the following error.

Error

Error

Operation on target Load Sales notebook failed: 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.)' :

I have a lake house created an atached.

User's image

Code as is the instructionsUser's image

please help me

This question is related to the following Learning Module

Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
945 questions
Accepted answer
  1. Rakesh Gurram 2,925 Reputation points Microsoft Vendor
    2024-04-24T10:06:09.52+00:00

    Hi Richard Hernandez,

    Please follow these steps and retry:

    At the left side of the notebook please click on Lakehouses.

    User's image Click on Add Lakehouse.

    image (1)

    Select the Lakehouse where the table resides. Attach the Lakehouse to the notebook.

    image (2)

    Now try to execute the notebook, this might help you in resolving the error message.

    I hope this helps. 

    Please Accept Answer & Upvote so that it would be helpful to community members.

    Thank you.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest