I would like to verify the intended functionality of UPSERT because I’m experiencing unexpected results when using the MySQL Export feature.
My understanding is that the UPSERT should essentially look for the primary key in the database, and anytime it sees a match, then it should update (overwrite the values) for all of the rest of the columns for that row in the database (with the data from the Parabola run).
However, each time I press ‘Run’ it creates new rows in my MySQL database (rather than updating the existing rows as intended). I have verified that the primary key (‘id’) has the exact same numbers in both the database & the Parabola data flow, however the desired update is not happening.
This screenshot shows my settings and primary key column:
This screenshot illustrates how I pressed ‘Run’ 3 minutes apart, and they ended up as new entries in my database (with duplicate IDs) instead of updating the existing ID with new value in the timestamp column:
Do you happen to see where I may be going wrong? I really appreciate it!