New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
You ran an UPDATE without a WHERE clause, and now every row in the table is wrong.
What you'll have at the end
The table restored to the exact state it was in a set number of minutes ago, verified row by row
You need
A live Snowflake table with Time Travel still switched on, which is the default on every table, and enough privilege on it to read its history and swap it out.
Not covered
A table that got dropped or replaced outright rather than just updated wrong; that calls for undropping it instead of anything here.
Zero-copy clone production for a safe sandbox
reach for that one when you want a safe copy of production to experiment against, not to undo a mistake that already landed
A bad write on a lakehouse table, rolled back with time travel
if the table lives in an open lakehouse format instead of native Snowflake storage, its own snapshot rollback fixes this with no copy or swap needed
Checked 26 Aug 2026
Part of the Snowflake Data Cloud cookbook