Forum Discussion

rafiqahmed's avatar
rafiqahmed
Frequent Visitor
1 year ago
Solved

Read and write to different lakehouses using notebook in same workspace

Hello,

My goal is to read data from one lakehouse table, clean the table and save in another lakehouse in same workspaces.

 

 

I am getting table not fund error:

df = spark.sql("SELECT * FROM GoldLakehouse.SalesInvoiceHeaders LIMIT 1000")
display(df)

 


 

 

lakehouse
notebook
  • rafiqahmed's avatar
    rafiqahmed
    1 year ago

    The problem is solved for me.

     

    I created the second lakehouse using Lakehouse Schemas checkbox checked. 

    That might be causing the issue, I deleted the lakehouse and created again with Lakehouse schemas checkbox unchecked. Open notebook , Now I can read from one lakehouse table and write to other lakehouse table in same workspace.

     

    Thanks

     

2 Replies

  • rafiqahmed's avatar
    rafiqahmed
    Frequent Visitor
    1 year ago

    The problem is solved for me.

     

    I created the second lakehouse using Lakehouse Schemas checkbox checked. 

    That might be causing the issue, I deleted the lakehouse and created again with Lakehouse schemas checkbox unchecked. Open notebook , Now I can read from one lakehouse table and write to other lakehouse table in same workspace.

     

    Thanks

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi rafiqahmed,

       

      Thank you for sharing your update and confirming that you dont have any issue. i request you to please accept your own post as the solution, this will help other community members who might face a similar issue.

       

      Regards,

      Vinay Pabbu