Table Maintenance and Optimization

Efficiently managing your tables helps ensure that your queries run quickly and reliably. Dremio provides three key methods for managing tables:

• Table Cleanup with Vacuum – Use the VACUUM CATALOG command to remove expired snapshots and orphaned metadata files.

• Optimize Tables – Use the OPTIMIZE TABLE command to compact small files, split large files, or repartition data.

• Automated Maintenance with Dremio Catalog - Enable automated optimization and table cleanup for your cluster's built-in Dremio Catalog.