Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session. As such, they are not visible to other users or sessions. Once the session ends, data stored in the table is purged completely from the system and, therefore, is not recoverable, either by the user who created the table or Snowflake.
actually reading Snowflake documentation they recommend temporary tables for ETL jobs. If you could please remove my comment dear moderator that says D.
My understanding is Transient will be the more suitable answer as this table will be used during the ETL operations on the contrary Temp tables are session-oriented and used for temporary purposes although Transient tables reside and are available after ETL ops and as they are not fail-safe and 0-1 day of time-travel so quite economical then Permamanet
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.
dinubecse
3 weeks agoMitchdu
1 month, 3 weeks agonsyilmazer
4 months, 1 week agonsyilmazer
4 months, 1 week agoPrashantGupta1616
8 months, 2 weeks agoahadh7621
9 months agoMitchdu
1 month, 3 weeks agoLematthew31
9 months, 4 weeks agoconverteo_certif
9 months, 1 week agoMultiCloudIronMan
1 year, 7 months ago