How to Delete Rows in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

Use DELETE FROM ... WHERE to remove matching rows. To empty a table entirely, TRUNCATE TABLE is faster. Deleted data stays recoverable during the Time Travel retention window.

DELETE FROM orders WHERE status = 'cancelled';

DELETE FROM orders
USING customers c
WHERE orders.customer_id = c.id
  AND c.is_test_account = TRUE;

SELECT * FROM orders AT(OFFSET => -60*10); -- table as of 10 minutes ago