An Iceberg table's object storage size has grown excessively over six months due to retained snapshots. What operation should be run?
Select an answer to reveal the explanation.
Short Explanation and Infographic
expire_snapshots is the Iceberg maintenance procedure that removes snapshot metadata older than a specified timestamp and deletes any data files referenced only by those expired snapshots; reclaiming storage space.
Full explanation below image
Full Explanation
expire_snapshots is the Iceberg maintenance procedure that removes snapshot metadata older than a specified timestamp and deletes any data files referenced only by those expired snapshots; reclaiming storage space. The incorrect options ("ALTER TABLE ... DROP PARTITION to remove old partitions", "TRUNCATE TABLE to remove all data and restart ingestion", "VACUUM TABLE which is equivalent to the Iceberg maintenance operation") are distractors that don't fully capture the concept described.