How to Update Rows in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

Use UPDATE ... SET ... WHERE. Without a WHERE clause every row is updated, so always scope it. To update from another table, add a FROM clause and join condition.

UPDATE orders
SET status = 'shipped'
WHERE id = 42;

UPDATE orders o
SET o.region = c.region
FROM customers c
WHERE o.customer_id = c.id;