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

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.