C4_W4 practice lab - Stuck at running dbt

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
1

I get to step 2.3 - Running Analytical Views
When I enter the command to run dbt, I get the following error

Compilation Error
dbt found two schema.yml entries for the same resource named annual_sells_per_office_view. Resources and their associated columns may only be described a single time. To fix this, remove the resource entry for annual_sells_per_office_view in one of these files:

  • models/analytical_views/.ipynb_checkpoints/schema-checkpoint.yml
    models/analytical_views/schema.yml

Any guidance on resolving this would be appreciated

2

Hello @dan_herman,
Could you go to VSCode and browse the files in the upper left corner. There should be a folder models/analytical_views.Inside find and delete that file with the exlamation mark schema-checkpoint.yml. If the problem continues you can delete the schema.yml you created in the lab and create a new one after dbt run pass. Hope it helps

3

Looks like it worked! Thank you again for the quick response! Cheers!

1 Like