fix: user-facing duplicate handling workflow for bucket-based connectors (backport of #2077)

fix: user-facing duplicate handling workflow for bucket-based connectors (backport of #2077) #1235