Make dbt snapshot command work on Oracle target #458
Description
Describe the feature
With Trino using a catalog in Oracle as a target, the following error is thrown when executing dbt snapshot:
TrinoUserError(type=USER_ERROR, name=NOT_SUPPORTED, message="This connector does not support modifying table rows", query_id=20241203_215122_00342_xjxt3)
On inspection of the queries run against the database we saw that MERGE statements were being used, but Trino documentation shows that MERGE clauses are not supported in combination with Oracle.
Please implement dbt snapshot without MERGE statements on Oracle target.
Describe alternatives you've considered
Use dbt-oracle directly without Trino.
Who will benefit?
No response
Are you willing to submit PR?
- Yes I am willing to submit a PR!