Hi, I am experiencing issues with the practice lab at the stage of running the dbt views.
It says:
The schema file and the package.yml files are filled with the expected info.
The schema file and the package.yml files are filled with the expected info.
Hello @Kiril_Milev
I did a little research, and this issue is probably stemming from the sql files missing the .sql extension at the end of their file names. For example, you might have saved the avg_sells_per_product_line_view.sql as avg_sells_per_product_line_view. Moreover, be aware that dbt model names are case sensitive, and you should input analytical_views in all the steps with lower case characters.
I suggest checking your files with the provided solution files. Since this is a practice lab, you have access to all the solution files, and you can compare them with your own to find the mismatches.
Hi Amir,
Unfortunately that is not the problem,
I have compared it with solution - the code is the same.
My structure of the files is as follows:
Today I’ve started everything from start but still getting an error.
Regards,
Kiril
@Kiril_Milev the folder you were supposed to create in step 2.1.2 is created in a wrong path.
The analytical_views folder should be under the models folder, not the star_schema folder.
Thanks Amir,
My mistake was that when clicking on the models to create the new folder I didn’t click entirely on the name - models, but partially on the star schema.