DBT Tutorial : How to structure DBT project

[@reddyreddy-np4zx]

Man, amazing work. Can't wait....Subscribed! Do keep the videos coming, please?

[@anirvandecodes]

Thanks! Will do!

[@saketsrivastava84]

Very nice explained

[@anirvandecodes]

Thank you so much 🙂

[@srinathravichandran8796]

Awesome tutorials.. keep the good work going...when can we expect tutorials on other tools like airflow, airbyte etc ?

[@anirvandecodes]

thank you so much , I have two more videos dbt to complete the playlist , will plan after that

[@ChinnaDornadula]

4 completed ❤

[@mihirit7137]

I have copied the yml file in the folder staging, marts, I am getting the conflict to rename the yml sources , how do we effectively define sources in the models

[@anirvandecodes]

Can you share the complete error text and project structure?

[@mihirit7137]

@@anirvandecodes so in your video you pasted the yml file containing sources in the all the 3 folders, since the source is the same for all 3 files I just pasted the model sql files inside the folder and kept the yml file outside the folder so this resolved the error, I believe with the new dbt version you cannot have 2 yml files having the same source referencing the same table at the same folder level currently my folder structure looks like models -staging - - staging_employee_details.sql -intermideate - - intermideate _employee_details.sql -marts - - marts_employee_details.sql -employee_source.yml in the video you pasting the yml file in each 3 folders (staging, intermideate, marts) which gives naming_conflict_error your videos have been very informative, I went through the whole playlist was struggling to install dbt on my system and understand it thank you so much ! 😄😄

[@anirvandecodes]

@ i think you might have same spirce name mentioned in two place , take a look into that

[@mihirit7137]

@@anirvandecodes dbt found two sources with the name "employee_source_EMPLOYEE". Since these resources have the same name, dbt will be unable to find the correct resource when looking for source("employee_source", "EMPLOYEE"). To fix this, change the name of one of these resources: - source.dbt_complete_project.employee_source.EMPLOYEE (models\marts\marts_employee_source.yml) - source.dbt_complete_project.employee_source.EMPLOYEE (models\staging\stg_employee_source.yml)

[@mihirit7137]

should the source name always be unique ?