UNDROP ICEBERG TABLE¶

Restores the most recent version of a dropped Iceberg table.

This topic refers to Iceberg tables as simply “tables” except where specifying Iceberg tables avoids confusion.

See also:: CREATE ICEBERG TABLE , ALTER ICEBERG TABLE , DROP ICEBERG TABLE , SHOW ICEBERG TABLES , DESCRIBE ICEBERG TABLE

Syntax¶

UNDROP ICEBERG TABLE <name>

Copy

name: Specifies the identifier for the table to restore. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Restoring Iceberg tables is only supported in the current schema or current database, even if the table name is fully-qualified.
If an Iceberg table with the same name already exists, an error is returned.
To undrop an Iceberg table whose external volume has been dropped, undrop the external volume first. You can’t undrop the Iceberg table by creating a new external volume with same name as the dropped external volume.
You can’t restore a table that uses an external catalog if the associated catalog integration has been dropped.

UNDROP relies on the Snowflake Time Travel feature. An object can be restored only if the object was deleted within the Data Retention Period. The default value is 24 hours.

Restore the most recent version of a dropped table my_iceberg_table:

UNDROP ICEBERG TABLE my_iceberg_table;

Copy