I am new in EasyMorph, I am enjoying discovering all the available actions and how they are useful for our use cases.
Need your advice to find the best way to do the following:
Use case: We have a daily process that is moving data to Snowflake based on Last Update Date, daily process is taking all registers that were updated or modified since Yesterday, then I need to insert in case the register does not exist or update in case register exists, based on an ID column.
I found a way to do that follwoing the next steps:
- Move data to temporal table in Snowflake (only what was changed/modified since yesterday).
- Run a custom script using MERGE (Snowflake command) to update/insert data.
My question is, that is my best option?
Thank you in advance for your help