Build a multi-task workflow

orders ──→ by_category ──→ combine
       └─→ by_region   ──↗

{
  "name": "Learn - category and region summary",
  "tasks": [
    {
      "name": "orders",
      "sql": "WITH orders(id, category, region, amount) AS (\n  VALUES\n    (1, 'Books', 'North', 20),\n    (2, 'Games', 'South', 30),\n    (3, 'Games', 'North', 15),\n    (4, 'Books', 'North', 40),\n    (5, 'Garden', 'South', 25),\n    (6, 'Garden', 'North', 10)\n)\nSELECT id, category, region, amount FROM orders;",
      "settings": {
        "current_catalog": "default",
        "namespace": [
          "default"
        ],
        "time_zone": "UTC",
        "case_sensitive": false,
        "ansi_enabled": true
      }
    },
    {
      "name": "by_category",
      "sql": "SELECT category, SUM(amount) AS sales\nFROM order_rows\nGROUP BY category\nORDER BY category;",
      "settings": {
        "current_catalog": "default",
        "namespace": [
          "default"
        ],
        "time_zone": "UTC",
        "case_sensitive": false,
        "ansi_enabled": true
      }
    },
    {
      "name": "by_region",
      "sql": "SELECT region, SUM(amount) AS sales\nFROM order_rows\nGROUP BY region\nORDER BY region;",
      "settings": {
        "current_catalog": "default",
        "namespace": [
          "default"
        ],
        "time_zone": "UTC",
        "case_sensitive": false,
        "ansi_enabled": true
      }
    },
    {
      "name": "combine",
      "sql": "SELECT 'category' AS dimension, category AS label, sales\nFROM category_totals\nUNION ALL\nSELECT 'region' AS dimension, region AS label, sales\nFROM region_totals\nORDER BY dimension, label;",
      "settings": {
        "current_catalog": "default",
        "namespace": [
          "default"
        ],
        "time_zone": "UTC",
        "case_sensitive": false,
        "ansi_enabled": true
      }
    }
  ],
  "dependencies": [
    {
      "upstream": "orders",
      "downstream": "by_category",
      "input_name": "order_rows"
    },
    {
      "upstream": "orders",
      "downstream": "by_region",
      "input_name": "order_rows"
    },
    {
      "upstream": "by_category",
      "downstream": "combine",
      "input_name": "category_totals"
    },
    {
      "upstream": "by_region",
      "downstream": "combine",
      "input_name": "region_totals"
    }
  ],
  "options": {
    "execution_target": "DuckDb"
  },
  "policy": "Manual"
}