Hi all, I'm transfering data from mySql to Postgres with the Sync mode INCREMENTAL / Decuped + History. I used this mode because I just want to have unique data in my destination-table. In this sync mode airbyte creates a XXX_scd and _airbyte_raw_XXX table for each table which are getting bigger and bigger now. Is it possible to clean the tables (truncate?) them?

Currently you should not truncate them because all the tables are rebuilt during a sync from scratch using the content of

_airbyte_raw_XXX

tables as their source of data Once this ticket is merged, released and you upgrade to that version, you could be able to truncate those “extra” tables because the final tables will be upserted not overwritten https://github.com/airbytehq/airbyte/issues/4286