Scheduling multiple jobs (workflows) in DABs

Greg_c
New Contributor II

Hello, I'm wondering how can I schedule multiple jobs (workflow).

I'd like to do something like this but on a workflow level.

 

      tasks:
        - task_key: task_1
          sql_task:
            warehouse_id: ${var.warehouse_id}
            parameters:
                ...
            file:
              path: ../src/task_1.sql

        - task_key: task_2
          depends_on:
            - task_key: drop_tables
          sql_task:
            warehouse_id: ${var.warehouse_id}
            parameters:
                ...
            file:
              path: ../src/task_2.sql

 

and what I want is a master workflow like

 

      jobs/workflows:
        - job/workflow_key: workflow_1
            file:
              path: ../resources/workflow_1.sql

        - job/workflow_key: workflow_2
          depends_on:
            - workflow_key: workflow_1
            file:
              path: ../resources/workflow_2.sql

 

I'd really appreciate any resources/examples on this - thank you!