What happens when a table or schema with a standard retention period is dropped?
What happens when a table or schema with a standard retention period is dropped?
This time, I say D. It will be retain in the Time Travel, as per data retention period
When you drop a table or schema in Snowflake that uses the standard Time Travel retention period, the object is not deleted immediately. Instead, it is retained in Snowflake’s Time Travel for the configured retention period (1 day by default in Standard Edition). During this window, you can restore the object using UNDROP. After Time Travel expires, permanent objects move into Fail‑Safe for an additional 7 days (recoverable only by Snowflake), and finally are purged permanently.