top of page
Search

Recover Deleted Tables from Fabric Lakehouse

  • Writer: Ishan Deshpande
    Ishan Deshpande
  • 3 days ago
  • 2 min read

In the previous blog post, we explored how time travel works in Delta tables and how it can be used to recover deleted rows. But what if the entire Delta table is deleted—how do you recover it?

That’s exactly what we’ll cover in this blog post.


Install semantic-link-labs


To achieve this, we need install the semantic-link-labs library. You can do it in your notebook using the following command:

%pip install semantic-link-labs

However, I recommend creating a custom environment and adding this library to it, so you don't have to install it every time you start a new session.


Steps to Create a Custom Environment:


  1. Go to your Fabric workspace, click on New, select Environment, and give it a meaningful name.



  1. Once its created, go to Public Libraries, and click Add from PyPI.



  1. Add semantic-link-labs and click Publish.



Once published:

  • Open your notebook.

  • Go to Environment > Change Environment.

  • Select the custom environment you just created.


Note: When using a custom environment, the session startup time will increase to 2–3 minutes.


Now you're all set!


What Can You Do with semantic-link-labs?


The semantic-link-labs library is a toolkit developed by Microsoft for working with Microsoft Fabric artifacts using Python. It allows you to interact with various Microsoft Fabric artifacts including

  • Semantic models

  • Reports

  • Capacities

  • Lakehouse


In this blog, we'll focus on using the recover_lakehouse_object function to restore a deleted Delta table or files. To use this function, we just need 3 things - Table Path, Lakehouse Name & Workspace Name.

import sempy_labs.lakehouse as lake

lakehouse = 'API_Lakehouse' # Enter the name or ID of the lakehouse
workspace = 'Fabric_API_Test' # Enter the name or ID of the workspace in which the lakehouse exists

# Example 1: Recover a delta table
lake.recover_lakehouse_object(file_path='Tables/emp', lakehouse=lakehouse, workspace=workspace)

Here's a quick demo



Note: You can only recover objects that were deleted within the last 7 days.


Here are some resources that will help you to get started


Conclusion


Recovering data is a critical part of any data engineering workflow, especially when working with large-scale Lakehouse systems. With Semantic Link Labs, Microsoft Fabric provides a robust, developer-friendly way to restore accidentally deleted Delta tables—within a 7-day window. By setting up a reusable environment and learning to use key functions like recover_lakehouse_object, you can safeguard your data pipeline against unintended data loss.


That's all for this blog see you in next one!




bottom of page