[Bug] "dbt compile" is giving Compilation Error

[techwithshadab]

Is this a new bug in dbt-core?

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

Current Behavior

dbt compile is giving Compilation Error

dbt found two macros named "group_by" in the project "media_datalake". To fix this error, rename or remove one of the following macros:

• dbt_packages/dbt_expectations/macros/utils/groupby.sql
• dbt_packages/dbt_utils/macros/sql/groupby.sql

Expected Behavior

dbt compile should run successfully without giving the above error

Steps To Reproduce

Package Version dbt-core==1.8.6 dbt-snowflake==1.8.3

Packages YML file

packages:
  - package: dbt-labs/dbt_utils
    version: 1.3.0
  - package: dbt-labs/codegen
    version: 0.12.1
  - package: dbt-labs/audit_helper
    version: 0.12.0
  - package: dbt-labs/dbt_project_evaluator
    version: 0.13.2
  - package: dbt-labs/dbt_external_tables
    version: 0.9.0
  - package: calogica/dbt_expectations
    version: 0.10.3

Relevant log output

No response

Environment

- OS: MacOS Sonoma 14.6.1
- Python:3.9.6

Which database adapter are you using with dbt?

snowflake

Additional Context

No response

[giuliosmall]

@techwithshadab The error you’re encountering is due to a naming conflict between the group_by macros defined in both the dbt_expectations and dbt_utils packages. When two macros share the same name in your project, dbt doesn’t know which one to use, leading to a compilation error.

[dbeatty10]

@techwithshadab thanks for opening this issue!

@giuliosmall good point about the potential root cause. But in this case, I'd expect for this to work just fine since the groupby macro is namespaced to each of the source packages.

For example, this worked for me:

dbt clean
dbt deps
dbt compile -s my_model

Here's the output I got:

$ dbt compile -s my_model
12:28:02  Running with dbt=1.8.6
12:28:04  Registered adapter: snowflake=1.8.3
12:28:04  Found 49 models, 1 seed, 29 data tests, 1003 macros
12:28:04  
12:28:06  Concurrency: 10 threads (target='snowflake')
12:28:06  
12:28:06  Compiled node 'my_model' is:
select 1 as id
group by 1
-- group by 1

Here's the file that I used

models/my_model.sql

select 1 as id
{{ dbt_utils.group_by(1) }}

@techwithshadab Could you share a simple model file that gives this error for you and also share the commands you used?

Could you also share your dbt_project.yml file? I'm wondering if you are overriding the macro-paths config or setting the dispatch, etc.