Read and write to different lakehouses using notebook in same workspace

[rafiqahmed]

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)

[rafiqahmed · Accepted solution]

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]

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