How to Delete in Redshift

To delete rows in a Redshift table, use the DELETE FROM statement:

DELETE FROM products WHERE product_id=1;

The WHERE clause is optional, but you'll usually want it, unless you really want to delete every row from the table.

Cta

From Redshift query to chart to Slack in seconds

Get to answers faster, together, with PopSQL and Redshift