How to Update Rows in Redshift

Last updated July 25, 2026 · By the SaturnSQL team

Use UPDATE ... SET ... WHERE, with FROM to join another table. Under the hood Redshift marks old rows deleted and appends new ones, so large updates leave dead rows that VACUUM later reclaims.

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

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