Changing Write Mode

Changing the write mode can cause data discrepancies in your destination. Only proceed if you’re sure how this will affect your data.

When editing your flow, you can change a write mode for your destination.

Usually, changing the write mode will not disturb the database but in some cases, the change will significantly affect the flow and data in your data destination

MySQL, PostgreSQL, MSSQL, Redshift & Vertica

When creating a flow to MySQL, PostgreSQL, MSSQL, Redshift, or Vertica, the structure of the table to which the data is inserted is determined.
If you select UPSERT write_mode, then the "Indexing" is used for that table in the database. Other write_modes do not create indexes. If the flow is created with a different write mode, changing the write mode to UPSERT later will not work for the table.