# VACUUM and ANALYZE Iceberg Tables

**URL:** <https://community.dremio.com/t/vacuum-and-analyze-iceberg-tables/12799>\
**Category:** Uncategorized\
**Created:** [February 19, 2025, 9:11am UTC](https://community.dremio.com/t/vacuum-and-analyze-iceberg-tables/12799 "2025-02-19T09:11:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![abukreev](https://avatars.discourse-cdn.com/v4/letter/a/3da27b/32.png) [@abukreev](https://community.dremio.com/u/abukreev)\
**Post date:** [February 19, 2025, 9:11am UTC](https://community.dremio.com/t/vacuum-and-analyze-iceberg-tables/12799/1 "2025-02-19T09:11:42Z")

</div>

I create table via SQL in Dremio. Data was inserted by Spark after that . SELECT query is working.  
But when I try run ANALYZE or VACUUM I have error - `Unable to find requested dataset ...`

---

<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:** [February 19, 2025, 11:08pm UTC](https://community.dremio.com/t/vacuum-and-analyze-iceberg-tables/12799/2 "2025-02-19T23:08:49Z")

</div>

@abukreev I just tried on the table I created via Spark SQL and Vacuum works fine. It could be possible that either the full path is not set or the context is not set right .Can you please try this, navigate to the dataset via the Dremio UI then click the copy icon to the right of the table name and then use that in your command, see screenshot below

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/9/9a84ff93b4312f49a3f0b0d592a1ad7a2f949b11.png)

---

<div class="post-metadata">

**Author:** ![abukreev](https://avatars.discourse-cdn.com/v4/letter/a/3da27b/32.png) [@abukreev](https://community.dremio.com/u/abukreev)\
**Post date:** [February 20, 2025, 11:16am UTC](https://community.dremio.com/t/vacuum-and-analyze-iceberg-tables/12799/3 "2025-02-20T11:16:22Z")

</div>

@balaji.ramaswamy I use Nessie catalog and and I think the reason for this problem is this

 ![Screenshot 2025-02-20 at 12.58.32](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/8/87c36f232bbc54849bc8e7874983bbf2d75d29ab.png)

---

<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:** [February 24, 2025, 9:17pm UTC](https://community.dremio.com/t/vacuum-and-analyze-iceberg-tables/12799/4 "2025-02-24T21:17:31Z")

</div>

@abukreev For Nessie only VACUUM CATALOG is supported