[Feature] Documenting quoting

[johalnes]

Describe the Feature

Hi,

Not really a feature, but suggestion for improving the documentation or readme.

I had big trouble with the error message table already exists. In the logs it stood that no intermediate or backup relation was found, and therefore not deleted.

After quite a lot of searching I found that quoting also is an issue with Oracle. And found that in the test project in this repository you specify the following in the dbt_project file:

quoting:
  database: false
  schema: false
  identifier: false

This solved all of my trouble. Maybe this should be suggested at either the installation page on dbt adapter page or at the beginning of the readme file?

Describe alternatives you've considered

On Snowflake they have changed the defaults:

Could be an idea if this is recommended for all users of Oracle?

Who will this benefit?

No response

Anything else?

No response

[aosingh]

@johalnes Thank you for reporting this issue. Sorry that you had to go through the trouble. We want to make dbt-oracle simple and easy. I can update the documentation.

Default quoting parameters are all False. Did you have any quoting options enabled before ?
is this an on-prem database ? I need this information to update documentation for different Database (on-prem, cloud, etc)