Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
yash_robin
New Member

How to save a table in Fabric Lakehouse

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.

2 ACCEPTED SOLUTIONS
v-gchenna-msft
Community Support
Community Support

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:

vgchennamsft_0-1714733984038.png

 


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

View solution in original post

frithjof_v
Skilled Sharer
Skilled Sharer

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...

 

View solution in original post

5 REPLIES 5
yash_robin
New Member

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

Hi @yash_robin ,

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

frithjof_v
Skilled Sharer
Skilled Sharer

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
Community Support
Community Support

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:

vgchennamsft_0-1714733984038.png

 


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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.