How to save a table in Fabric Lakehouse

[yash_robin]

Hi all,

While I am exploring Fabric Notebooks, I can find we can attach multiple lakehouse in notebook.

I would like to know is there a way to save the data in table/file in lakehouse, which is not default.

[v-gchenna-msft · Accepted solution]

Hi @yash_robin ,

Thanks for using Fabric Community,

Inorder to save your file in a lakehouse apart from the default lakehouse you need to use ABFS path and if you are saving it as a table try using lakehouse_name.table_name

Please find the screenshot below:

Hope this is helpful. Please feel free incase of any queries.

[yash_robin]

Thank you Everyone for your help.! It was helpful.

[v-gchenna-msft]

Hi @yash_robin ,

Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.

[frithjof_v · Accepted solution]

I think if you want to read or write from another lakehouse in the same workspace as the notebook's default lakehouse (the one marked with the pin icon), then you can use lakehouse_name.table_name notation.

If you want to read or write from a lakehouse in another workspace than the notebook's default lakehouse, then I think you need to use the full abfss path.

For more on this topic, ref.:

https://community.fabric.microsoft.com/t5/General-Discussion/Writing-to-a-Lakehouse-in-different-wor...

https://community.fabric.microsoft.com/t5/General-Discussion/Failed-to-create-table-and-schema/m-p/3...

[v-gchenna-msft · Accepted solution]

Hi @yash_robin ,

Thanks for using Fabric Community,

Inorder to save your file in a lakehouse apart from the default lakehouse you need to use ABFS path and if you are saving it as a table try using lakehouse_name.table_name

Please find the screenshot below:

Hope this is helpful. Please feel free incase of any queries.

[v-gchenna-msft]

Hi @yash_robin ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Thanks