Time Travel in Snowflake — Step by Step Part 1 – Class 33 скачать в хорошем качестве

Time Travel in Snowflake — Step by Step Part 1 – Class 33

Time Travel in Snowflake allows you to access historical data that was changed or deleted within a defined retention period. It helps recover accidentally deleted data, restore previous versions of records, and audit changes. Snowflake automatically maintains historical versions of data. In Standard Edition, the default retention period is 1 day. In Enterprise Edition and above, it can be set from 0 to 90 days. You can check the retention period using: SHOW PARAMETERS LIKE 'DATA_RETENTION_TIME_IN_DAYS'; You can set retention at the table level like this: ALTER TABLE employees SET DATA_RETENTION_TIME_IN_DAYS = 2;