Managing Retention of Only the Last 7 Days' Data in Dremio Reflections

1

Hi Team,

We aim to retain only the last 7 days of data in a Dremio reflection. Each day, the data for day 8 should be deleted, ensuring that only the most recent 7 days of data are preserved. Is this functionality supported in Dremio, and if so, how can we implement this deletion in the reflection?

Thanks in Advance

2

Hi team,

Can you please provide an update on above points

Thanks in Advance

3

@JoiceJacob

You may create reflections containing dynamic functions such as NOW and CURRENT_TIME to meet your requirement of only the last 7 days of data. Data refresh for these reflections containing dynamic functions is always full refreshes and will always have data for last 7 days from the time refresh was run.

thanks