oracle/dbt-oracle

[Bug] Quoting Identifier True and Persist docs

PoleDecisionnelBAO opened this issue · 3 comments

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

If the Quoting Identifier parameter is set to True, column comments do not work with persist_docs

Expected Behavior

In the file adaptaders.sql I change this line

comment on column {{ relation }}.{{ column_name }} is {{ escaped_comment }}

to

comment on column {{ relation }}.{{adapter.check_and_quote_identifier(column_name, model.columns)}} is {{ escaped_comment }}

and it works for me

Steps To Reproduce

No response

Relevant log output using --debug flag enabled

No response

Environment

No response

What Oracle database version are you using dbt with?

19c

Additional Context

No response

hi @PoleDecisionnelBAO

Thank you for reporting the issue and also suggesting the fix. I have included the fix in the next release candidate version

pip install dbt-oracle==1.7.2rc1

Could you please test with this and let me know if it works ?

yes it works. Thank

dbt-oracle==1.7.2 is released with the fix.