I have a query running as an update to capture the data from source data extension and put it on target Data extension as update the matching records and insert new if not matching.

Yesterday we have added a new field in the target data extension to get the data from the source data extension. This field was already present in the source Data extension.

Issue is my query ran and the newly added field is coming as a blank but the value is present in the source data extension field.

Records are coming from source data extension to target but all records are having the newly created field as a blank.

Why do I observe this behavior? How do I fix it?


You will need to re-save your query. The query itself is saved and hard-coded on the Marketing Cloud's side and any type of updates like this will not automatically carry over. This is why it is best practice to specify each column name in your query so you avoid this and are forced to update the query anytime you update fields in your data extensions.

This is mentioned in our docs here: SQL Query Activity

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.