Update Data in Snowflake in Snowflake

PHOTO EMBED

Wed May 19 2021 19:06:46 GMT+0000 (UTC)

Saved by @zscherrer #sql

--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;
content_copyCOPY

https://popsql.com/learn-sql/snowflake/how-to-update-data-in-snowflake