Introducing PopSQL + dbt
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;
Spread the word