I would like to know how to do a sync through source_node_id through columms transforms. X The table will update a record in table y, and I want it to update the record that it is (identified by source_node_id)
id | name | source_node_id
1 | a | 3
2 | a | 5
record in the table x (source_node_id = 3) to update the record id = 1.
tx