Dynamic Snowflake: Update Column Value Instantly from Another Table

Justin Aug 25, 2026

In the world of data management and analysis, updating column values from another table is a common operation, especially in today's sophisticated data warehouses and data lakes. Snowflake, a cloud-based data warehouse, provides several methods to accomplish this task efficiently. Let's delve into how you can update column values in one table by fetching data from another table in Snowflake.

About Calculating Sales depending on another Value in DAX | Towards Data Science
About Calculating Sales depending on another Value in DAX | Towards Data Science

Before we start, ensure that you have the necessary privileges to execute the UPDATE statement and that the tables involved are in the same or a shared schema. Also, keep in mind that updating data can have significant impacts, so it's crucial to double-check your syntax and source data.

a long table with candles and snowflakes hanging from it
a long table with candles and snowflakes hanging from it

Updating Column Values Using JOIN Clause

The JOIN clause is a powerful tool that allows you to combine rows from two or more tables based on a related column between them. To update column values using a JOIN clause, you'll need to combine data from both tables and then update the target table.

Sum a Column Based on Values in Another - Excel University
Sum a Column Based on Values in Another - Excel University

Here's an example of updating the 'sales' table's 'sales_amount' column using a JOIN with the 'products' table: ```sql UPDATE sales AS s SET s.sales_amount = p.price * s.quantity FROM products AS p WHERE s.product_id = p.id; ``` In this snippet, we're using an inner JOIN to match 'product_id' in the 'sales' table with 'id' in the 'products' table, then updating 'sales_amount' based on the product's price and the quantity sold.

Using CROSS JOIN or any other join types

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

In some cases, you might need to use a CROSS JOIN or other join types to update column values. For instance, consider a case where you have two unrelated tables, and you want to update one table's column based on specific conditions from the other table. In this situation, you can use a CROSS JOIN to combine data from both tables and then apply the UPDATE statement. ```sql UPDATE t1 SET t1.column1 = t2.column2 FROM ( SELECT column1, column2 FROM table2 ) AS t2 CROSS JOIN t1 WHERE t1.id = t2.id AND t1.other_column = t2.other_column; ``` In this example, we're using a CROSS JOIN to combine data from 'table1' and 'table2', then updating 'column1' in 'table1' based on 'column2' from 'table2'.

Make sure to use appropriate filtering conditions in the WHERE clause to avoid unwanted updates.

Updating multiple columns with a single UPDATE statement

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

Suppose you want to update multiple columns from another table. You can achieve this by specifying multiple column assignments separated by commas in the SET clause. ```sql UPDATE sales AS s SET (s.sales_amount, s.sales_date) = (p.price * s.quantity, NOW()) FROM products AS p WHERE s.product_id = p.id; ``` In this scenario, we're updating both 'sales_amount' and 'sales_date' columns simultaneously using a single UPDATE statement.

Always ensure that the derived values for the updated columns are appropriate and make sense for your dataset.

Updating Column Values Using MERGE Statement

how many snowflakes? counting worksheet for kids to practice number recognition
how many snowflakes? counting worksheet for kids to practice number recognition

The MERGE statement is a more elegant way to update data in Snowflake, as it allows conditional updates, inserts, and deletes in a single statement. To use the MERGE statement for updating column values, you'll first need to define the source data and then specify the conditions for updating, inserting, or deleting rows.

Here's an example of updating 'sales' table's column values using the MERGE statement: ```sql MERGE INTO sales AS t USING ( SELECT id, price, quantity, NOW() AS sales_date FROM products ) AS s ON (t.product_id = s.id) WHEN MATCHED THEN UPDATE SET sales_amount = s.price * s.quantity, sales_date = s.sales_date WHEN NOT MATCHED THEN INSERT (product_id, sales_amount, sales_date) VALUES (s.id, s.price * s.quantity, s.sales_date); ``` In this case, the MERGE statement combines data from the 'products' table as the source, then matches and updates or inserts values into the 'sales' table accordingly.

the snowflake data info sheet is shown
the snowflake data info sheet is shown
a dining room table with white snowflakes hanging from the ceiling
a dining room table with white snowflakes hanging from the ceiling
Snowflake Centerpieces That Bring the Chill Vibes in the Best Way
Snowflake Centerpieces That Bring the Chill Vibes in the Best Way
the snowflake data platform is shown in this info sheet, with information about how to use it
the snowflake data platform is shown in this info sheet, with information about how to use it
a white snowflake on a blue background
a white snowflake on a blue background
the pixel snowflakes are all different sizes and colors
the pixel snowflakes are all different sizes and colors
Snowflake - Database
Snowflake - Database

You can also include additional conditions in the ON clause to filter the matched and unmatched rows.

Using MERGE with other operations like deletes

A powerful feature of the MERGE statement is that it allows conditional deletes, making it a versatile tool for managing data. In cases where you need to remove unwanted or duplicate records, you can use the MERGE statement's WHEN NOT MATCHED BY SOURCE THEN DELETE clause. ```sql MERGE INTO duplicates AS t USING ( SELECT id, column1, column2 FROM master_table ) AS s ON (t.id = s.id) WHEN MATCHED THEN UPDATE SET column1 = s.column1, column2 = s.column2 WHEN NOT MATCHED BY SOURCE THEN DELETE; ``` In this situation, the MERGE statement combines data from the 'master_table', then matches and updates or deletes rows in the 'duplicates' table. The WHEN NOT MATCHED BY SOURCE THEN DELETE clause allows you to remove unmatched or duplicate records.

The MERGE statement simplifies data management by combining multiple operations into a single statement, making it an efficient and effective way to update column values in Snowflake.

With a solid understanding of JOIN clauses, the UPDATE statement, and the MERGE statement, you're well-equipped to tackle various data update scenarios in Snowflake. Start exploring these powerful tools today and watch your data analysis skills grow. Happy updating!