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.
Previous
How to UpdateFrom Redshift query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and Redshift