Restores the most recent version of a dropped Apache Iceberg™ table.
This topic refers to Iceberg tables as simply “tables” except where specifying Iceberg tables avoids confusion.
CREATE ICEBERG TABLE , ALTER ICEBERG TABLE , DROP ICEBERG TABLE , SHOW ICEBERG TABLES , DESCRIBE ICEBERG TABLE
UNDROP ICEBERG TABLE <name>
Copy
Parameters¶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.
This command isn’t supported for tables in a catalog-linked database.
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
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4