You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Basically the question above.
I started out trying to process some events in a lambda (reading a jsonl file from a S3 object notification). And for testing purposes I processed the same file twice and obviously that duplicates the event.
Is there a reason it doesn't support a merge into strategy where we specify the merge_cols?
Generate a query like
MERGE INTO table USING temp_table
ON (table.merge_col = temp_table.merge_col)
WHEN MATCHED THEN UPDATE
SET col1 = temp_table.col1 ...
WHEN NOT MATCHED THEN INSERT (col1 ...)
VALUES(temp_table.col1 ...)
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Basically the question above.
I started out trying to process some events in a lambda (reading a jsonl file from a S3 object notification). And for testing purposes I processed the same file twice and obviously that duplicates the event.
Is there a reason it doesn't support a merge into strategy where we specify the merge_cols?
Generate a query like
Beta Was this translation helpful? Give feedback.
All reactions