How to Delete Data in Snowflake

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

delete from sessions where id = 7;

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

delete from sessions;
database icon
Shared queries and folders ✅ Version history ✅ One-click connection to Snowflake ✅
Get more done, together, with PopSQL and Snowflake