How to do Delta Loads into SQL

Question

How would you do Delta Loads into Snowflake tables?

I have been looking on snowflakes documentation but I haven't been able to find anything on the topic.

Thanks

Try Snowflake Merge: https://docs.snowflake.net/manuals/sql-reference/sql/merge.html — Ambrish, Dec 19 '18 at 00:39
Delta load can be handled in few ways , it's not snowflake dependent rather it's the way you implement it. As mentioned in the comment above merge is one way. Plain insert if you know there are no old data comming. — Fact, Jan 25 '19 at 06:45

score 1 · Answer 1 · answered Oct 17 '21 at 11:21

1

Merge would be the standard way to do this in Snowflake:

answered Oct 17 '21 at 11:21

Robert Long

1

You're on a necro roll today. You realise Halloween is still weeks away? ;) – MatBailie Oct 17 '21 at 11:24
@MatBailie when you can't find new questions to answer ;) – Robert Long Oct 17 '21 at 11:26

1 Answers1