Snowflake Update Row Value

Justin Aug 25, 2026

In the dynamic world of data management, updating records efficiently is a crucial task. Snowflake, a cloud-based data warehousing platform, offers a simple yet powerful command for updating row values, which we'll delve into in this guide.

Snowflake Business Model: How Snowflake Works And Makes Money
Snowflake Business Model: How Snowflake Works And Makes Money

The Snowflake UPDATE statement is analogous to other SQL databases, but with some unique features that leverage the power of Snowflake's architecture. Let's explore this command and its capabilities.

Functions in Snowflake (2025): Complete Guide for Data Transformation & Analytics
Functions in Snowflake (2025): Complete Guide for Data Transformation & Analytics

Understanding the Snowflake UPDATE Statement

The Snowflake UPDATE statement allows you to modify existing records in your tables. It consists of the UPDATE keyword followed by the table name, a SET clause to specify the columns and new values, and a WHERE clause to target specific rows.

the pixel snowflakes are all different sizes and colors
the pixel snowflakes are all different sizes and colors

One of the key advantages of Snowflake's UPDATE statement is its ability to process large datasets and support concurrent updates, ensuring optimal performance and minimal downtime.

Syntax and Basic Usage

How to Transform Your Data in Snowflake - KDnuggets
How to Transform Your Data in Snowflake - KDnuggets

Here's the basic syntax of the Snowflake UPDATE statement:

```sql UPDATE table_name SET column1 = new_value1, column2 = new_value2, ... WHERE condition; ```

Replace table_name with the name of your table, column1 and column2 with the names of the columns you want to update, and new_value1 and new_value2 with the new values. The condition in the WHERE clause determines which rows to update.

Updating Multiple Columns and Rows

a blue and white poster with information about snowflakes in english, spanish, and
a blue and white poster with information about snowflakes in english, spanish, and

You can update multiple columns by separating them with commas in the SET clause. Similarly, you can update multiple rows by using appropriate conditions in the WHERE clause. Here's an example:

```sql UPDATE my_table SET column1 = new_value1, column2 = new_value2, column3 = new_value3 WHERE condition1 OR condition2; ```

The statement above will update column1, column2, and column3 for all rows that meet the conditions defined in condition1 OR condition2.

Advanced Features of Snowflake UPDATE

Perficient Blogs
Perficient Blogs

Besides the basic syntax, Snowflake's UPDATE statement offers several advanced features to cater to specific use cases.

Snowflake supports multi-row updates with the MERGE statement, which combines the functionality of the UPDATE and INSERT INTO statements. This is particularly useful when you have a destination table with existing data that you want to update or insert into based on certain conditions.

Star Schema vs Snowflake schema for Data Warehouse
Star Schema vs Snowflake schema for Data Warehouse
Snowflake vs. Databricks: What’s the Real Difference?
Snowflake vs. Databricks: What’s the Real Difference?
How Snowflake plans to change a flawed data warehouse model - SiliconANGLE
How Snowflake plans to change a flawed data warehouse model - SiliconANGLE
Resource Library
Resource Library
Snowflake review: A data warehouse made better in the cloud
Snowflake review: A data warehouse made better in the cloud
Snowflake Cost & ROI Calculator | Snowflake Pricing Estimator | Jade
Snowflake Cost & ROI Calculator | Snowflake Pricing Estimator | Jade
❄️ ✨ Enchanting Snowflakes: Nature's Delicate Masterpieces ✨ ❄️
❄️ ✨ Enchanting Snowflakes: Nature's Delicate Masterpieces ✨ ❄️

Concurrent Updates with MERGE

The MERGE statement in Snowflake enables concurrent updates, allowing multiple users or processes to update the same table simultaneously without blocking each other. This ensures optimal performance and improved data manipulation capabilities.

Here's the basic syntax of the Snowflake MERGE statement:

```sql MERGE INTO destination_table USING source_table ON (source_condition = destination_condition) WHEN MATCHED THEN UPDATE SET column1 = new_value1, column2 = new_value2 WHEN NOT MATCHED THEN INSERT (destination_columns) VALUES (source_column_values); ```

In this syntax, source_table is the table containing the data you want to update or insert, and destination_table is the table where you want to perform the updates or inserts. The ON clause specifies the join condition between the source and destination tables. The WHEN MATCHED and WHEN NOT MATCHED clauses define the update or insert actions.

Upsert with INSERT INTO ... ON CONFLICT

Starting from Snowflake 3.15, the INSERT INTO statement supports an ON CONFLICT clause, which performs an upsert operation, updating existing records or inserting new ones based on the conflict resolution strategy you define.

Here's how you can use it:

```sql INSERT INTO my_table SELECT * FROM source_table ON CONFLICT (column1, column2) DO UPDATE SET column1 = EXCLUDED.column1, column2 = EXCLUDED.column2; ```

In this example, the statement will insert or update the rows from source_table into my_table based on the unique combination of column1 and column2. If a conflict occurs, it will update the existing row with the new values from the EXCLUDED table, which holds the new row's data.

Snowflake's UPDATE capabilities, including the advanced MERGE and upsert features, empower users to efficiently manage and manipulate their data with minimal effort and maximal performance.

As you've seen, Snowflake's UPDATE statement and its advanced features allow for flexible and efficient data manipulation. By understanding and leveraging these capabilities, you can streamline your data management workflows and take full advantage of Snowflake's cloud-based architecture. So go ahead and start updating your data with confidence!