Scheduling multiple jobs (workflows) in DABs
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2025 03:14 AM - edited 01-27-2025 03:15 AM
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!