Hello, how would it be possible to have a loading strategy which is a “full-refresh append partition”, but only create one new partition per day. Multiple runs per day should replace the partition of the current day.
It seems that airbyte allows to overwrite a table but not a partition. How could I implement that?