Converting Permanent table to Transient Table in Snowflake

404

nVector

posted on

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




Good Approach... But thinking what will be the ideal cases for having transient table...

Anything like a table that is loaded only for processing and then gets truncated at the end of the process.. ? Right Assumption ?

what about any other clone and Data Shared objects placed on the permanant table?