# Dremio iceberg delete expire Snapshots

**URL:** https://community.dremio.com/t/dremio-iceberg-delete-expire-snapshots/9416
**Category:** Uncategorized
**Created:** [July 17, 2022, 7:37pm UTC](https://community.dremio.com/t/dremio-iceberg-delete-expire-snapshots/9416 "2022-07-17T19:37:11Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![dacopan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dacopan/32/4289_2.png) [@dacopan](https://community.dremio.com/u/dacopan)
#### Post date: [July 17, 2022, 7:37pm UTC](https://community.dremio.com/t/dremio-iceberg-delete-expire-snapshots/9416/1 "2022-07-17T19:37:11Z")

</div>

Hello friends, thanks by this amazing tool, in past Days I reported somes bugs, but this is another question, currently I’ve a history table created with CTA usign `INSERT INTO` clause but as how Iceberg work by each insert a new snapshoot is created, so if I run this many times a day, we have a lot of expired snaphoots  
how can delete this snapshoots throutgh Dremio

---

<div class="post-metadata">

### Author: ![dch](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dch/32/4140_2.png) [@dch](https://community.dremio.com/u/dch)
#### Post date: [July 19, 2022, 3:30am UTC](https://community.dremio.com/t/dremio-iceberg-delete-expire-snapshots/9416/2 "2022-07-19T03:30:22Z")

</div>

Cleanup/optimization/compaction is not currently implemented however we are actively looking into it.
