Which objects can be restored after being dropped?
Snowflake retains dropped permanent and transient tables for their Time Travel retention period, allowing them to be restored with UNDROP TABLE. Transient tables have no Fail-safe period after Time Travel expires, but remain recoverable during that retention window. Dropped views and materialized views must be recreated; materialized views cannot be recovered.
UNDROP TABLE
Community Discussion