Parameters and query context

{
  "name": "Learn - parameterized orders",
  "tasks": [
    {
      "name": "summarize",
      "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 category, SUM(amount) AS sales\nFROM orders\nWHERE region = :region AND amount >= :minimum_amount\nGROUP BY category\nORDER BY category;",
      "settings": {
        "current_catalog": "default",
        "namespace": [
          "default"
        ],
        "time_zone": "UTC",
        "case_sensitive": false,
        "ansi_enabled": true
      }
    }
  ],
  "dependencies": [],
  "options": {
    "execution_target": "DuckDb"
  },
  "policy": "Manual",
  "parameters": {
    "region": {
      "type": "string",
      "required": true,
      "default": "North",
      "enum": [
        "North",
        "South"
      ]
    },
    "minimum_amount": {
      "type": "integer",
      "required": true,
      "default": 0
    }
  }
}