[Bug] dbt-oracle 1.9.0 does not support new snapshot improvements in dbt-core 1.9.0+

[pauldalewilliams]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

New snapshot improvements in dbt-core 1.9.0+ are not supported. For example, hard_deletes config does not work and does not seem to get translated to the invalidate_hard_deletes legacy config option.

Expected Behavior

dbt-oracle 1.9.0 should support new snapshot improvements in dbt-core 1.9.0+

Steps To Reproduce

Attempt to use new snapshot config. e.g.:

snapshots:
  - name: test_snapshot
    relation: ref('schema', 'test')
    config:
      hard_deletes: new_record

Relevant log output using --debug flag enabled

Environment

- OS: debian 12 (bookworm)
- Python: 3.12.8
- dbt: 1.9.1

What Oracle database version are you using dbt with?

19c

Additional Context

https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-v1.9#snapshots-improvements
https://docs.getdbt.com/reference/snapshot-configs#snapshot-configuration-migration
https://docs.getdbt.com/reference/resource-configs/hard-deletes
https://docs.getdbt.com/reference/resource-configs/snapshot_meta_column_names
https://docs.getdbt.com/reference/resource-configs/dbt_valid_to_current

[aosingh]

Hi @pauldalewilliams

Thank you for bringing this to our attention. We will plan to include these enhancements in the next version. I will keep you updated.

[aosingh]

@pauldalewilliams This is currently under development targeted for release v1.9.1. We plan to release this week