How to Update Data in Snowflake?

Snowflake Update

Generally, we will update the rows that match a particular condition. We will update the rows by declaring the “WHERE” clause.

Snowflake Update Table for Single Row

Example:

update sessions1
set start_date = ‘2022-05-03 11:15:13.430’
      end_date  = ‘2022-07-25 12:30:20.321’
where id = 2;

For Multiple Rows

We use the following code to update multiple rows.

update sessions1
set end_date = null
where category = 2;

For updating all the rows in the Snowflake table, just use the “UPDATE” statement without the “WHERE” clause:

update sessions1
set end_date = ‘2022-08-09 15:45:57.753’

To update multiple rows at a time, use the below code:

update sessions1
set start_date = ‘2022-09-09 15:50:57.625’
      end_date  = ‘2022-07-06 17:50:55.737’ 

Conclusion

This blog teaches you to update the data of a single row and multiple rows. We hope this blog provides you with the required information about updating the data in the Snowflake table. If you have any queries, let us know by commenting below. 

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop

▶  Snowflake Time Travel