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.
nsyilmazer
1 month agonsyilmazer
1 month agoPrashantGupta1616
5 months, 1 week agoahadh7621
5 months, 4 weeks agoLematthew31
6 months, 3 weeks agoconverteo_certif
6 months agoMultiCloudIronMan
1 year, 4 months ago