Sign In

How to Update Data in Snowflake

Usually you only want to update rows that match a certain condition. You do this by specifying a WHERE clause:

--this will update only one row that matches id = 1
update sessions
set start_date = '2020-04-20 10:12:15.653',
    end_date = '2020-04-22 15:40:30.123'
where id = 1;

--this will update multiple rows that match category = 1
update sessions
set end_date = null
where category = 1;

To update all rows in a Snowflake table, just use the UPDATE statement without a WHERE clause:

update sessions
set end_date = '2020-04-04 16:57:53.653';

You can also update multiple columns at a time:

update sessions
set start_date = '2020-04-02 14:05:15.400',
    end_date = '2020-04-04 16:57:53.653';
Cta

From Snowflake query to chart to Slack in seconds

Get to answers faster, together, with PopSQL and Snowflake
Sign up for free

Previous

How to Insert Data

Next

How to Delete Data