According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
For data that can be recreated outside of Snowflake, a transient table should be used. Transient tables do not have the same data protection and recovery mechanisms as permanent tables, but they provide a cheaper storage option because they retain their data until explicitly dropped or replaced. Unlike temporary tables, transient tables can be accessed by multiple sessions and persist beyond the current session but do not incur the cost of fail-safe retention.
https://docs.snowflake.com/en/sql-reference/sql/create-table
https://hevodata.com/learn/snowflake-temporary-table/
B is the correct answer
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.
Agree with C
Can someone explain why Temporary tables cannot be the answer in this case? They can both be used and I haven't found any docs stating otherwise.