Hi expert,

I have a question regarding Delta loads. I've been using a data connection from AWS RedShift to Celonis. Before performing both the full loads and delta loads, I copy the target table, rename, and re-tied to perform Full loads and Delta loads. The full load consistently succeeds, but the delta load encounters issues.

Here's the error message for the a_size_result table:

• Datatype of the column size_l changed from FLOAT to STRING.
• Table won't be delta loaded. Please perform a full load instead.

When I reviewed the delta load log, I noticed that there was a change in the metadata for the 'ds_if_scm$_CELONIS_a_size_result' table.

After full loads the data, I checked the data type in RedShift (String) and the Celonis Data Pool (Varchar).

Could an expert please explain why this error occurs during delta loads?

Thanks,