[Bug]: Dots in the schema name do not parse correctly

[brock-acryl]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

When using a dot (.) in a schema name, dbt will parse this and split out the schema to read:
"samples"."dremio"."com"
instead of
"samples.dremio.com"

Expected Behavior

dbt should parse schema as: "samples.dremio.com"

Steps To Reproduce

Create a schema.yaml file containing the following

sources: 
  - name: samples
    database: Samples
    schema: samples.dremio.com
    tables:
      - name: NYC-weather.csv
      - name: NYC-taxi-trips-iceberg

Environment

- OS: Windows 10 / Mac OSX
- dbt-dremio: commit: 388f540fecde5706d11364caf18937553d31ae13
- Dremio Software: Enterprise 24.1
- Dremio Cloud: 8/15/23

Relevant log output

No response

[brock-acryl]

To fix this issue:

Add to line 22
import re

Replace Line 50 with:

PATTERN = re.compile(r'''((?:[^."']|"[^"]*"|'[^']*')+)''') 
return ".".join(PATTERN.split(identifier)[1::2])

Create your schema using double quotes when specifying a single space/folder and single quotes around the entire schema like the following:

sources:
  - name: weather
    database: Samples
    schema: '"samples.dremio.com"'
    tables:
      - name: NYC-weather.csv
  - name: nyc
    database: Samples
    schema: '"samples.dremio.com"."Dremio University"'
    tables:
      - name: sample_data

[lethalazo]

could you open a PR for the fix you suggested please