Currently, in the Redshift [destination], Fivetran is executing a soft delete operation by marking the _fivetran_deleted  field as TRUE. We need to set up certain tables in a way that allows Fivetran to carry out hard delete operations, thereby removing the record in the destination automatically. This setup will ensure that the table remains an exact mirror of the source and avoid steps like DELETE or DROP command to hard-delete rows deleted from the source, or write post-load transformations to delete data where _fivetran_deleted = TRUE.