Hi Team, In our dbt project, we set to set quoting identifier to variable with default value as true. We need it to be true as we have one of the table with name as GROUP which is keyword. For elementary model creation we have set quoting to false, since elementary models are generated in lower case and to create tables/views in snowflake they need to be case insensitive. We are receiving error in on_run_end hook, where it seems like it is not using quoting.

05:11:33  on-run-end failed, error:
05:11:33   When searching for a relation, dbt found an approximate match. Instead of guessing 
05:11:33  which relation to use, dbt will move on. Please delete "TEAM_MONITORING_INGEST"."TEAM_ELEMENTARY_ARTIFACTS"."DATA_MONITORING_METRICS", or rename it to be less ambiguous.
05:11:33  Searched for: TEAM_MONITORING_IG.TEAM_ELEMENTARY_ARTIFACTS.data_monitoring_metrics
05:11:33  Found: "TEAM_MONITORING_IG"."TEAM_ELEMENTARY_ARTIFACTS"."DATA_MONITORING_METRICS"

Can any one please help us to resolve this?

Hi Nehal - you can run

edr report --help

and see some of the options available. One of which is:

-dq, --dbt-quoting TEXT        Use this variable to override dbt's default quoting behavior for the edr internal dbt package. Can be one of the following: (1)
all, (2) none, or (3) a combination of database,schema,identifier - for example "schema,identifier"

We are not explicitly running elementary commands, we have included elementary models in our dbt project. We are getting this issue with on_run_end hook. In elementary dbt_project.yml I see hook is added like this

on-run-start:
  - "{{ elementary.on_run_start() }}"
on-run-end:
  - "{{ elementary.on_run_end() }}"