-
Notifications
You must be signed in to change notification settings - Fork 74
Description
Describe the bug
Quotes in fully-qualified database name for sources.
What version of dbt Fusion is this bug in? (find out by running dbt --version)
Is this a discrepancy between the dbt Fusion Engine and dbt Core? Check one.
- YES
- NO
To Reproduce
- Open this workspace
- Follow the instructions in the README
Create these files:
dbt_project.yml
name: 'my_project'
profile: 'snowflake'
quoting:
database: true
identifier: true
schema: truemodels/_sources.yml
sources:
- name: my_source
database: my_database
schema: my_schema
tables:
- name: my_tablemodels/my_model.sql
{{
config(
materialized='incremental',
incremental_strategy='insert_overwrite',
)
}}
select *
from {{ source("my_source", "my_table") }}Using a Snowflake target, compare the compiled SQL in the target directory after each of these commands:
fs compile -s my_modeldbt compile -s my_modelOne uses quotes for each part of the fully qualified database name for the source and the other does not.
Expected behavior
I expected Core and Fusion to have the same compiled output.
Namely, for sources to use the quoting config for sources which is different than the quoting config for ref'd resources
Screenshots
If applicable, add screenshots to help explain your problem.
Operating System and CPU Type (please complete the following information):
- Mac/Windows/Linux?
- X86 or ARM?