- Explore
- Collaborate
- Visualize
- Connect
- Pricing
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';
From Snowflake query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and Snowflake
Previous
How to Insert Data
From Snowflake query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and Snowflake