[Feature] implement delete+insert incremental strategy

[push2prod]

Describe the Feature

implementation of delete+insert incremental strategy

Describe alternatives you've considered

using a pre hook on the model to delete the data or trying to implement the custom strategy myself, the first seems prone to error and the later convoluted

Who will this benefit?

dbt offers different strategies to make incremental models. the ones currently implemented are append and merge (as I understand). although they are not fit for all use cases. for example when reruns are desired and the table has no key

Anything else?

https://docs.getdbt.com/docs/build/incremental-models#about-incremental_strategy

[aosingh]

@push2prod

We have added support for delete+insert incremental strategy in upcoming dbt-oracle release 1.7.3

Could you test it with the release candidate ?

pip install dbt-oracle==1.7.3rc2

[aosingh]

@push2prod

Please test delete+insert incremental strategy with release 1.7.3

pip install dbt-oracle==1.7.3