Home  >  Blog  >   Snowflake  > 

How to Update Data in Snowflake

Snowflake is the data warehouse platform that handles and store our data in a flexible, reliable, and transparent way. It enables us to easily update our data without migrating or recreating our database. In this blog, you will learn how to update your data in Snowflake.

Rating: 4.6
  
 
223
  1. Share:
Snowflake Articles

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.

Preparing for Snowflake Interview? Here’s Top Snowflake Interview Questions and Answers
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:

MindMajix YouTube Channel

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

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingJun 28 to Jul 13
Snowflake TrainingJul 02 to Jul 17
Snowflake TrainingJul 05 to Jul 20
Snowflake TrainingJul 09 to Jul 24
Last updated: 27 June 2022
About Author
Viswanath V S

Viswanath is a passionate content writer of Mindmajix. He has expertise in Trending Domains like Data Science, Artificial Intelligence, Machine Learning, Blockchain, etc. His articles help the learners to get insights about the Domain. You can reach him on Linkedin