"Transient tables do not have a Fail-safe period. They are designed to minimize storage costs by not retaining historical data."
> "Transient tables can be cloned to create permanent tables."
> "Transient tables persist until they are explicitly dropped by the user."
> "Transient tables cannot be altered to become permanent tables. You would need to create a new permanent table and migrate the data."
> "Transient tables have a Time Travel retention period of either 0 or 1 day."
Transient tables are a type of table in Snowflake that persist until they are explicitly dropped. They do not have a Fail-safe period, and they can only have a Time Travel retention period of 0 or 1 day. Transient tables cannot be cloned to permanent tables, and they cannot be altered to make them permanent tables.
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.
MultiCloudIronMan
5 months, 2 weeks agononamae
8 months, 4 weeks agorajukg
9 months, 2 weeks agopvskbrod
9 months, 3 weeks agoJG1984
10 months agofannaa
10 months, 1 week agoMultiCloudIronMan
11 months, 3 weeks agohappykeieiekek
11 months, 3 weeks ago