QuestionQ46Verified/Implement disaster recovery, perform backups, and replicate dataCopy linkReport a problemAsk AstroTutorSave questionWhich Snowflake capabilities are typically used for rollback scenarios?Choose twoASELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);BCREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => ‘problematic_query_id’);CCREATE TABLE prd_table_bkp as SELECT * from table(result_scan(‘problematic_query_id’()));DALTER TABLE prd_table SWAP WITH prd_table_bkp;EContact Snowflake Support to retrieve Fail-safe data.Show AnswerAnswerExplanationA 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 referenceLearn moreUnderstanding & using Time TravelALTER TABLE | Snowflake DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion