KaranamS
Contributor III

Hi @Locomo_Dncr , 

The default retention time for Time travel files is 7 days. If your retention period is more than that, maintaining historical data in bronze layer is better than relying on Time travel. Time travel is best suited for short term access and requires log retention management where as historical bronze table offers better control and query performance especially for larger datasets.

Hope this helps!