{
  "name": "pl_sample_orchestration",
  "properties": {
    "parameters": {
      "p_source_path": { "type": "string", "defaultValue": "landing/source" },
      "p_sink_path": { "type": "string", "defaultValue": "curated/target" },
      "p_env": { "type": "string", "defaultValue": "dev" }
    },
    "activities": [
      {
        "name": "Copy_Source_To_Staging",
        "type": "Copy",
        "policy": { "retry": 2, "retryIntervalInSeconds": 30 },
        "inputs": [{ "referenceName": "ds_source", "type": "DatasetReference" }],
        "outputs": [{ "referenceName": "ds_staging", "type": "DatasetReference" }]
      },
      {
        "name": "Validate_Staging",
        "type": "Script",
        "dependsOn": [{ "activity": "Copy_Source_To_Staging", "dependencyConditions": ["Succeeded"] }],
        "typeProperties": {
          "scripts": [{ "type": "Query", "text": "EXEC dbo.usp_validate_staging;" }]
        }
      },
      {
        "name": "Promote_To_Curated",
        "type": "ExecutePipeline",
        "dependsOn": [{ "activity": "Validate_Staging", "dependencyConditions": ["Succeeded"] }],
        "typeProperties": { "pipeline": { "referenceName": "pl_curated_merge", "type": "PipelineReference" } }
      }
    ],
    "annotations": [
      "sample-only",
      "add alert hooks in your monitor/notify pipeline",
      "use environment-specific linked services for promotion"
    ]
  }
}