updating tables in snowflake code example
Example: update snowflake
UPDATE t1
SET t1.number_column = t1.number_column + t2.number_column, t1.text_column = 'ASDF'
FROM t2
WHERE t1.key_column = t2.t1_key and t1.number_column < 10;
UPDATE t1
SET t1.number_column = t1.number_column + t2.number_column, t1.text_column = 'ASDF'
FROM t2
WHERE t1.key_column = t2.t1_key and t1.number_column < 10;