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 = 1update 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 = 1update sessions
set end_date =nullwhere 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';
