Knowledge Drop

Can I use a transient schema for PDTs?


Userlevel 3

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.                

 

 


0 replies

Be the first to reply!

Reply