Transient Vs Temporary Tables in Snwoflake |
Transient tables in Snowflake are similar to permanent tables, with the difference that
they do not have a fail-safe period.
Temporary tables exist only for a particular session. Transient tables
help in storing transient data that you require for multiple sessions but
do not require extra levels of data protection.
Both transient and temporary tables contribute to the overall storage limits of Snowflake for each user account.
#snowflake #datacloud #clouddata #datawarehouse