A data engineer accidentally overwrites critical data in an Iceberg table. What operational procedure can restore the table to its previous state?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Apache Iceberg supports snapshot-based rollback through the CALL system.rollback_to_snapshot() procedure; reverting the table's current snapshot pointer to a previous state without touching the underlying data files.
Full explanation below image
Full Explanation
Apache Iceberg supports snapshot-based rollback through the CALL system.rollback_to_snapshot() procedure; reverting the table's current snapshot pointer to a previous state without touching the underlying data files. The incorrect options ("Restore the table from a daily pg_dump backup of the metastore", "Re-ingest the original source data from scratch", "Delete the object storage bucket and recreate it from the COS backup") are distractors that don't fully capture the concept described.