merge in snowflake

rohit answered on April 27, 2021 Popularity 9/10 Helpfulness 2/10

answer merge in snowflake

related snowflake merge

merge in snowflake

Comment

merge into target using (select k, max(v) as v from src group by k) as b on target.k = b.k
  when matched then update set target.v = b.v
  when not matched then insert (k, v) values (b.k, b.v);

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: docs.snowflake.com

Tags: merge whatever

Link to this answer
Share Copy Link

Contributed on Dec 20 2021

rohit

0 Answers Avg Quality 2/10

Closely Related Answers

snowflake merge

Comment

MERGE INTO target USING (select k, max(v) as v from src group by k) AS b ON target.k = b.k
  WHEN MATCHED THEN UPDATE SET target.v = b.v
  WHEN NOT MATCHED THEN INSERT (k, v) VALUES (b.k, b.v);

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: docs.snowflake.com

Tags: whatever merge m

Link to this answer
Share Copy Link

Contributed on Apr 27 2021

Grotesque Gnat

0 Answers Avg Quality 2/10

merge in snowflake

Contents

More Related Answers

merge in snowflake

Closely Related Answers

snowflake merge

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.