Destination MySQL: enable support dedup sync option

[vijaybridgeme]

Enviroment

• Airbyte version: 0.30.23-alpha
• OS Version / Instance: macOS
• Deployment: Docker
• Source Connector and version: Doesn't matter
• Destination Connector and version: MySQL
• Severity: Medium
• Step where error happened: Setup new connection

Current Behavior

MySQL documentation says that it supports dedup. But in the connection page, dedup option does not show up.

"supportsDBT": true,
"supported_destination_sync_modes": ["overwrite", "append"],
"connectionSpecification": {
"$schema": "http://json-schema.org/draft-07/schema#",
"title": "MySQL Destination Spec",

Expected Behavior

Add "dedup" option in supported sync modes.

Logs

If applicable, please upload the logs from the failing operation.
For sync jobs, you can download the full logs from the UI by going to the sync attempt page and
clicking the download logs button at the top right of the logs display window.

LOG

replace this with
your long log
output here

Steps to Reproduce

Are you willing to submit a PR?

Remove this with your answer.

[ChristopheDuong]

There should be an SAT to make sure all destinations that currently support normalization have to support dedup sync options (and being tested for it)

[tq-tien]

I had the same issue. However, I configured "incremental || dedupe history" via API and it worked normally, although the UI showed nothing at sync mode buttons. That can be a workaround.