# Reflection Refresh

**URL:** <https://community.dremio.com/t/reflection-refresh/7196>\
**Category:** Uncategorized\
**Created:** [March 24, 2021, 5:35pm UTC](https://community.dremio.com/t/reflection-refresh/7196 "2021-03-24T17:35:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AjayBabuM](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ajaybabum/32/6736_2.png) [@AjayBabuM](https://community.dremio.com/u/AjayBabuM)\
**Post date:** [March 24, 2021, 5:35pm UTC](https://community.dremio.com/t/reflection-refresh/7196/1 "2021-03-24T17:35:39Z")

</div>

Hi Dremio Team,

Iam using Dremio 13.x community version and I need to know some cases like,

1. How to load few data(like last 7 days) from a table to incremental reflection insted of total data when reflection creation.
2. How to delete certain data (like \< 7 days old data) from incremental reflection.
3. Sys tables date columns are in UTC format can change to IST with an configuration.

Thanks,  
Ajay Babu Maguluri.

---

<div class="post-metadata">

**Author:** ![AjayBabuM](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ajaybabum/32/6736_2.png) [@AjayBabuM](https://community.dremio.com/u/AjayBabuM)\
**Post date:** [March 25, 2021, 5:37am UTC](https://community.dremio.com/t/reflection-refresh/7196/2 "2021-03-25T05:37:44Z")

</div>

Hi Team,

Waiting for update.

Thanks,  
Ajay Babu Maguluri

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [March 25, 2021, 7:44am UTC](https://community.dremio.com/t/reflection-refresh/7196/3 "2021-03-25T07:44:21Z")

</div>

@AjayBabuM

#1 Create a VDS with a filter clause that has only 7 days of data and then create the incremental reflection on top of the VDS. You need to set the refresh type to incremental on the PDS setting  
#2 Currently not supported  
#3 Use CONVERT\_TIMEZONE function

[http://docs.dremio.com/sql-reference/sql-functions/datetime-functions/](http://docs.dremio.com/sql-reference/sql-functions/datetime-functions/)