C since temporary tables are only available for the duration of a session, and they are not stored in Snowflake's permanent storage. This means that they do not incur any storage costs.
When working with ETL processes, you need to use distributed paradigms very often, so can't use Temporary tables. Transient tables are specifically design for ETL processes. Additionaly, ETL processes can take a lot of time, so Temporary tables, which only lives during the session, are impractible.
Temporary tables exist only for the duration of the session and do not incur long-term storage costs. However, they are not accessible across sessions, which can limit their use in complex ETL workflows.
Transient tables strike the right balance between cost-effectiveness and functionality for ETL processes.
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.
blitzzzz
Highly Voted 1 year, 11 months agotardigradum
Most Recent 3 weeks, 5 days agoMitchdu
6 months agonehanovigo
10 months, 1 week agoMultiCloudIronMan
1 year, 11 months ago