Capstone Project Part 1 - ETL and Data Modeling - dbt issue

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

After doing “dbt run -s serving_layer” I get below errors.

15:36:33 Completed with 5 errors and 0 warnings:
15:36:33
15:36:33 Compilation Error in model dates (models/serving_layer/dates.sql)
‘dbt_date’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.
15:36:33
15:36:33 Compilation Error in model dim_artists (models/serving_layer/dim_artists.sql)
‘dbt_utils’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.
15:36:33
15:36:33 Compilation Error in model dim_songs (models/serving_layer/dim_songs.sql)
‘dbt_utils’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.
15:36:33
15:36:33 Compilation Error in model dim_users (models/serving_layer/dim_users.sql)
‘dbt_utils’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.
15:36:33
15:36:33 Compilation Error in model fact_order_items (models/serving_layer/fact_order_items.sql)
‘dbt_utils’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.

15:36:33 Done. PASS=0 WARN=0 ERROR=5 SKIP=1 TOTAL=6

Then I did “dbt deps” and it still didn’t work.
(jupyterlab-venv) abc@c3b36d182580:~/workspace/dbt_modeling$ dbt deps
15:37:39 Running with dbt=1.8.1
15:37:39 Warning: No packages were found in packages.yml
15:37:39 Warning: No packages were found in packages.yml

Can you please point to the right direction to resolve this?

Thanks.

2

Hello @pdulapalli
The problem is with the files you created in the dbt_modeling/models/serving_layer. I think you have copied the files’ content from the Week 4 Lab: Data Visualization with DBT and Superset. In that lab, we installed dbt_utils and dbt_date using the packages.yml file. You can either right your .sql files without calling these libraries or install them before using. You can see the classicmodels_modeling/packages.yml file in the Week 4 Lab: Data Visualization with DBT and Superset lab for help.

3

@Amir_Zare That worked. Thank you so much.