Can I use a transient schema for PDTs?

Knowledge Drop

Last tested: Aug 19, 2020
 

What are transient schemas?
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#comparison-of-table-types

Can I use them?
Yes - Transient tables still need to be explicitly dropped, the difference with them and a permanent table is that there is a fail safe period for permanent tables of 7 days (in those 7 days, permanent tables can be restored with UNDROP TABLE, transient cannot)

This content is subject to limited support.                

Version history
Last update:
‎06-28-2021 11:46 AM
Updated by: