Temporary tables's lifespan is session. The workload type was not specified, so I assume the expected lifespan is longer than a session. Transient tables exist until deleted, but they are not protected by Failsafe and max Time Travel is 1 day. If the data is lost, it can be recreated externally, so no need in Failsafe or Time Travel.Therefore, potentially significant savings on storage costs.
C
As such, transient tables should only be used for data that can be recreated externally to Snowflake. Default: No value. If a table is not declared as TRANSIENT or TEMPORARY , the table is permanent. Transient tables have some storage considerations.
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.
bogdan_R
5 months agoazprepd
1 week, 1 day agoMatthieuDN
5 months, 3 weeks agoJacobr5000
8 months agoAlex_Ovidiu
9 months, 1 week ago663f98f
9 months, 3 weeks agonexerSnow
10 months, 1 week ago