[Regression] Quoting behavior for sources

[peterallenwebb]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

In dbt-core 1.7 and earlier, quoting behavior for sources was not controlled by the quoting configuration in dbt_project.yml, but newer versions of dbt also apply those settings to sources.

In older versions of dbt, this was rendered without quotes around the schema name. The change seems to be unintentional, and we would like to return to the previous behavior.

Steps To Reproduce

# dbt_project.yml
quoting:
  schema: True

# models/sources.yml
sources:
  - name: <sourcename>
...

Create a model that references the source, and note that source(, ) is rendered in recent versions as:

with source as (

    select * from <database>."<schema>".<tablename>

)

We can work around with a source which specifically overrides this setting:

# models/sources.yml
sources:
  - name: <sourcename>
    quoting:
      schema: False
...

Relevant log output

.

Environment

- OS: Ubuntu/macos
- Python: 3.11
- dbt: 1.8.latest

Which database adapter are you using with dbt?

snowflake

Additional Context

No response

[peterallenwebb]

Internal thread: https://dbt-labs.slack.com/archives/C05FWBP9X1U/p1729130247375769