Restores the most recent version of a dropped notebook.
CREATE NOTEBOOK , ALTER NOTEBOOK , DROP NOTEBOOK , SHOW NOTEBOOKS , DESCRIBE NOTEBOOK
name
Specifies the identifier for the notebook 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.
Notebooks can only be restored to the database and schema that contained the notebook at the time of deletion.
If a notebook 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.
The following example restores the most recent version of a dropped notebook named mynotebook (this example builds on the examples provided for DROP NOTEBOOK):
UNDROP NOTEBOOK mynotebook;
Copy
+--------------------------------------------+ | status | |--------------------------------------------| | Notebook mynotebook successfully restored. | +--------------------------------------------+
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