An idempotent task produces the same result whether it is run once or several times for the same interval. It is an essential property with retries and backfills: you replace or merge the interval's data (overwrite a partition, MERGE) rather than simply appending it, to avoid duplicates.
Example
DELETE FROM ventes WHERE jour = '{{ ds }}';
INSERT INTO ventes SELECT * FROM brut WHERE jour = '{{ ds }}';