Hi, is there any documentation / official best practices with some examples for the "delete rows" feature in the transformations output mapping?
I haven't found anything in the Academy, nor your documentation.
Thanks!
Where am I?
In Keboola you can ask and answer questions and share your experience with others!
Hi Matus, the feature is described briefly here https://help.keboola.com/transformations/mappings/#options-2. What is does is that it deletes existing rows matching the simple condition from the destination table. Just be aware that it deletes the rows before actual load. Meaning that if you update some rows with is_deleted=TRUE during processing current batch, the rows will be deleted the next execution (because they do not yet exist in the destination).