1 | initial version |
To convert a snowflake transient table to a permanent one, follow these steps:
Log in to your Snowflake account and open the database containing the transient table.
Execute the following SQL statement to create a new permanent table with the same schema as the transient table:
CREATE TABLE permtable LIKE transienttable;
Note: Replace "permtable" and "transienttable" with the names of the new permanent table and the existing transient table, respectively.
INSERT INTO permtable SELECT * FROM transienttable;
SELECT * FROM perm_table;
DROP TABLE transient_table;
Note: Dropping the transient table before verifying the data has been copied to the permanent table could result in data loss. Always verify the data before dropping the transient table.