I have a data extension that is being updated with a SQL query.
The data extension is already populated with data and I would like to change the field name for one of the fields.
I have already tested changing field names for columns with existing data and the values seem to be unaffected.
However, I am yet to test changing field names in DEs that are being referenced in a SQL query within an active automation.
If I change the field name and also update the corresponding SQL query that is referencing the old field name with the updated field name, are there any negative consequences to consider?
Thank you in advance!