Transient tables in Snowflake behave much like permanent tables except they have no Fail‑Safe period and support at most a 1‑day Time Travel retention window. When you drop a transient table, it is moved into Time Travel and can be undropped only within that retention period; after the 1‑day window lapses, the table (and its data) is permanently irrecoverable.
Snowflake didn't provide explicit information about the impact of dropping the transient table, but I have found this: https://hevodata.com/learn/what-is-snowflake-transient-table/.
"For instance, if a system failure occurs and a Transitory Table is dropped or lost, the data is no longer accessible by you or Snowflake after one day. As a result, it’s advisable to use Snowflake Transient Table only for data that does not require failure protection or can be recreated outside of Snowflake."
Hence, after max 1 day, the data will be lost.
Time Travel for Temporary and Transient tables is 0 or 1. Hence, even if the tables itself is no longer available for being used, it is possible to use it for 1 more day, if the Time Travel was set to 1. Hence, I vote C.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1 week, 6 days ago37ceea2
3 months ago37ceea2
3 months ago