Does dbt cloud support more than one job dependency

Help
1

I have a scheduling question regarding dbt Cloud. I need to set up Job AB to run once a week on Wednesdays, but only after Job A has completed. For context, Job A runs every day. I’ve tried using the available Trigger options, but this results in duplicate runs. How can I accomplish this without adding logic to the actual model? I tried to add a macro that would check for the day of the week as command 1 and added the model refresh as command 2 but this did not really do anything. Any insight is appreciated

Job AB set up

Command 1 dbt run-operation check_wednesday
Command 2 dbt run --select tag:wednesday
2

Hi, can you be more specific? what does check_wednesday do?

If it only checks if the current date is Wednesday, why don’t you just run job B instead of both?

3

check_wednesday macro checks if today is Wednesday and yes we want the Job AB to run on Wednesday after Job A finishes . Job AB is tied to models that only need refresh every Wednesday.

4

So the models in Job B are downstream of Job A models right? And both only run on Wednesday?

5

Job B models are dependent on the outputs from Job A. While Job A runs daily, the models associated with Job B only need to be refreshed every Wednesday.