Forum Discussion

eddy1980's avatar
eddy1980
New Member
2 years ago
Solved

Artifact not found when querying a table in a lakehouse using notebook in Fabric

I am using the new lakehouse in fabric which support schema. When I run below code to query a table. I got below error message. I am able to open the table in the lakehouse and cannot query it in no...
data engineering
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi eddy1980,

    In fact, I can run these code in both two lakehouses that enabled or not enabled schema: (I modify the code to remove the workspace and lakehouse prefix and setting the default lakehouse, invoke tables which existed in current default lakehouse)

     

    df = spark.sql("SELECT * FROM Question")
display(df)

     

     

    Snapshots:

    BTW, did the lakehouse sql endpoint succeed generated and sync the tables from lakehouse that you used? If not, I'd like to suggest you report to dev to help check the root cause and fix it more quickly.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi eddy1980,

I test with your script and it works well on my side. Have you setting the default Lakehouse of the notebook to quick reference this resource? In addition, you can try to directly use the 'table name' in query string if current table is hosted in the default dbo schema.

Regards,

Xiaoxin Sheng