View the original community article here
Last tested: Aug 19, 2020
What are transient schemas?
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)