v1.7.6 - Githubissues

oracle / dbt-oracle

dbt (data build tool) adapter for Oracle Autonomous Database

https://docs.getdbt.com/docs/core/connect-data-platform/oracle-setup

Apache License 2.0

46 stars 17 forks source link

v1.7.6 #145

Closed aosingh closed 3 months ago

aosingh commented 4 months ago

Upgraded oracledb driver to 2.2.1
Fixed SQL generation for delete+insert incremental append strategy. Corresponding Slack thread - https://getdbt.slack.com/archives/C01PWH4TXLY/p1717577761754019
```
insertinto  schema.table (col1, col2, col3)
(
   select col1, col2, col3
   from o$pt_test_xxxx100932446065
)
```

"module": "dbt-1.7.15" [0m10:09:38.080324 [info ] [Thread-2 (]: oracle adapter: Oracle error: ORA-00900: invalid SQL statement