Which Snowflake capabilities are typically used for rollback scenarios?
A Time Travel clone created with BEFORE (STATEMENT => ...) captures the table state immediately before the identified statement. ALTER TABLE ... SWAP WITH ... exchanges the restored clone and production table names in a single transaction, making the pre-change data available under the production table name. Snowflake Time Travel documentation Snowflake ALTER TABLE reference
BEFORE (STATEMENT => ...)
ALTER TABLE ... SWAP WITH ...
Community Discussion