Restores the most recent version of a dropped dynamic table.
CREATE DYNAMIC TABLE, ALTER DYNAMIC TABLE, DESCRIBE DYNAMIC TABLE, SHOW DYNAMIC TABLES, DROP DYNAMIC TABLE
UNDROP DYNAMIC TABLE <name>
Copy
Parameters¶name
Specifies the identifier for the dynamic 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.
For more information, see Identifier requirements.
A role used to execute this operation must have the following privileges at a minimum:
Privilege
Object
Notes
OWNERSHIP
The dynamic table that you want to undrop.
The USAGE privilege on the parent database and schema are required to perform operations on any object in a schema.
For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.
For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.
Usage notes¶To undrop a dynamic table, you must be using a role that has OWNERSHIP privilege on that dynamic table.
If a table with the same name already exists, an error is returned.
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 dynamic table:
UNDROP DYNAMIC TABLE my_dynamic_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