Managing Iceberg Tables

Dremio supports data manipulation language (DML) for Apache Iceberg tables, enabling you to load and mutate data directly in the Dremio data lake using standard SQL commands including insert, update, merge, and delete. As you load more data and mutate Iceberg tables, the number of snapshots and data files accumulate which can impact query performance. To manage these activities and help you keep Iceberg tables in Dremio optimized, you can run SQL commands inside Dremio Sonar to optimize and roll back tables.

Table management options:

• Concurrency in Apache Iceberg Tables
• Copying Data Into Apache Iceberg Tables
• Expiring Snapshots of Apache Iceberg Tables
• Optimizing Tables
• Rolling Back Tables