Forum Discussion

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

Time travel limit 7 days

Hi,   Is it possible to increase the retention limit for time travel above 7 days in Fabric?   Or is 7 days the maximum retention duration for time travel in Fabric?   Thank you 😀
data engineering
lakehouse
frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

Thank you v-cboorla-msft!

 

The Microsoft documentation you linked to is related only to data warehouse.

 

Is there any Microsoft documentation for time travel in Lakehouse?

 

Thank you 😀 

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

The maintenance feature allows me to select a retention threshold of more than 7 days:

 

 

Does this mean that there is no 7-day upper limit for time travel retention of Lakehouse tables, but only a 7-day upper limit for Warehouse tables?

  • frithjof_v's avatar
    frithjof_v
    Icon for Community Champion rankCommunity Champion
    2 years ago

    I also have a Lakehouse table with many versions (more than 1000 versions).

     

    I am still able to query the first version of this table from a Fabric Notebook (SELECT * FROM tableName VERSION AS OF 1), and this version is more than 1 month old.

     

    Does this mean that Fabric Lakehouse tables can have unlimited time travel?

    While Fabric Data Warehouse tables are restricted to 7 days time travel.