topic Re: How to save a table in Fabric Lakehouse in Data Engineering

How to save a table in Fabric Lakehouse

yash_robin — Fri, 03 May 2024 10:55:34 GMT

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.

Re: How to save a table in Fabric Lakehouse

Anonymous — Fri, 03 May 2024 10:59:56 GMT

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.

Re: How to save a table in Fabric Lakehouse

frithjof_v — Sat, 04 May 2024 15:17:00 GMT

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-workspace-from-Notebook/m-p/3831379#M6243

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

Re: How to save a table in Fabric Lakehouse

Anonymous — Mon, 06 May 2024 07:43:03 GMT

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

Re: How to save a table in Fabric Lakehouse

yash_robin — Mon, 06 May 2024 09:51:45 GMT

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

Re: How to save a table in Fabric Lakehouse

Anonymous — Mon, 06 May 2024 09:53:38 GMT

Hi @yash_robin ,

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