# How can the created table be automatically updated in an incremental manner

**URL:** https://community.dremio.com/t/how-can-the-created-table-be-automatically-updated-in-an-incremental-manner/8466
**Category:** Uncategorized
**Created:** [December 9, 2021, 6:37am UTC](https://community.dremio.com/t/how-can-the-created-table-be-automatically-updated-in-an-incremental-manner/8466 "2021-12-09T06:37:57Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![cancel](https://avatars.discourse-cdn.com/v4/letter/c/839c29/32.png) [@cancel](https://community.dremio.com/u/cancel)
#### Post date: [December 9, 2021, 6:37am UTC](https://community.dremio.com/t/how-can-the-created-table-be-automatically-updated-in-an-incremental-manner/8466/1 "2021-12-09T06:37:57Z")

</div>

![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/1/1514476b7f7020d68633100a9d81cdfe7989da18.png)  
For example, the table I created, how can I let it update the data automatically when source VDS updated?  
It seems that I can only use drop & create at present, but this can’t be done automatically, and it’s full update.

---

<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: [December 20, 2021, 6:28am UTC](https://community.dremio.com/t/how-can-the-created-table-be-automatically-updated-in-an-incremental-manner/8466/2 "2021-12-20T06:28:11Z")

</div>

@cancel Once the ETL is done you can refresh metadata on affected PDS

[https://staging-docs.dremio.com/dx37707/advanced-administration/metadata-caching/#near-real-time-metadata-refreshes](https://staging-docs.dremio.com/dx37707/advanced-administration/metadata-caching/#near-real-time-metadata-refreshes)