The use of which Snowflake table type will reduce costs when working with ETL workflows?
The use of which Snowflake table type will reduce costs when working with ETL workflows?
Transient tables are the most cost-effective option for ETL workflows in Snowflake. This is because transient tables do not incur the additional costs associated with fail-safe storage. Transient tables are designed for intermediate data that is not needed for long-term recovery, making them ideal for ETL processes where data is processed and moved quickly. Permanent tables, on the other hand, have higher storage costs due to fail-safe mechanisms, and temporary tables are session-specific and do not persist beyond the session's end.
correct
Answer is C: https://docs.snowflake.com/en/user-guide/tables-temp-transient Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data).
This is the correct quote from the docs. Thank you
It's D, not C. The question tells us about ETL. You are using Transient with ETL not Temporary, and the cost will be be also reduce with Transient
Also Think it's 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
Definitely Transient as ETL jobs may require you to NOT lose any data after a session.
actually reading Snowflake documentation they recommend temporary tables for ETL jobs. If you could please remove my comment dear moderator that says D.
Direct quote on using temp tables for ETL on this link: https://docs.snowflake.com/en/user-guide/tables-temp-transient
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.