Re-evaluate skip normalization if no new data feature

[gosusnp]

What

We introduced a feature to skip normalization in certain cases #9672.
However, following a reset, normalization should run as well because some clean up on the destination side are only done by normalization (https://github.com/airbytehq/oncall/issues/741)
This behavior has been disabled by #17574 as a mitigation.

Also for context, there might be some discussions about how to better handle resets which may impact this feature
(slack thread + https://github.com/airbytehq/airbyte-internal-issues/issues/999)

[gosusnp]

One option might be to not skip normalization following a reset as well.

[killthekitten]

@gosusnp I wanted to highlight #9663 as an additional variable for your evaluation. Currently, the default behavior is to run normalization even after the sync has failed, which under certain circumstances erases data from the destination on a failure.

[rach]

This issue make airbyte nearly unusable and very unstable. I think that's ok with having sync falling, but having it wiping the data is a big issue which make the tool unreliable

[tsh356]

Is this anywhere on the roadmap?

[davinchia]

Hi all, this is automatically handled by our Destinations today - any sort of typing and deduping is only run if needed.