dbt-labs / dbt-core

dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
https://getdbt.com
Apache License 2.0
9.25k stars 1.53k forks source link

[Bug] dbt found two macros named "materialization_table_default" in the project #10354

Closed vedanthv closed 5 days ago

vedanthv commented 5 days ago

Is this a new bug in dbt-core?

Current Behavior

I have started a new dbt project and have added a csv file in the seeds folder. When I run dbt seed command, I get the following error

Compilation Error
  dbt found two macros named "materialization_table_default" in the project
  "dbt".
   To fix this error, rename or remove one of the following macros:
      - macros\materializations\models\table\table.sql
      - macros\materializations\models\table.sql

I dont have anything in the macros folder but still get this error.

Expected Behavior

Expected behaviour would be to populate the database and run the model when I run dbt seed and dbt run

Steps To Reproduce

  1. Define the seed files in the \seed folder
  2. Define the models in \models folder.
  3. Run dbt seed followed by dbt run

Relevant log output

3:14:03  Running with dbt=1.5.0
13:14:04  Unable to do partial parsing because saved manifest not found. Starting full parse.
13:14:05  Encountered an error:
Compilation Error
  dbt found two macros named "materialization_table_default" in the project
  "dbt".
   To fix this error, rename or remove one of the following macros:
      - macros\materializations\models\table\table.sql
      - macros\materializations\models\table.sql

Environment

- OS: Windows 11
- Python: 3.9.10
- dbt: 1.5.0

Which database adapter are you using with dbt?

other (mention it in "Additional Context")

Additional Context

I'm using duckdb in the project.

Logs image

Folder Structure image

vedanthv commented 5 days ago

Solved the issue by creating a virtual environment and bumped the version of duckdb to 1.7.0 and python to 3.9.1