Property description

The pipelines asset defines custom SQL operations (= activities) that are executed after a workflow state change.

Minimal JSON

{
  "key": "",
  "name": "",
  "type": ""
}
{
  "key": "example_pipeline",
  "name": "Example Pipeline",
  "type": "dawiso_internal",
  "activities": [
    {
      "key": "example_update_attribute",
      "name": "Example Activity (Update Attribute)",
      "type": "sql_script",
      "statement": "UPDATE MR_Attribute SET Text_Value = \u0027automation finished\u0027 WHERE Object_Id = JSON_VALUE(\u0027__@JSON__\u0027, \u0027$.ObjectId\u0027)"
    }
  ]
}

Example can be used for callDataFactory automation action.

Nested properties

PropertyDescriptionValuesMandatory
keyUnique key of the asset. Used for referencing in the same package or other packages using packageKey#assetKey.stringYes
nameName of the asset, used as the default EN translation.stringYes
typeType of the pipeline. Supported options are: dawiso_internal, customer_specificstringYes
activitiesArray of activities (SQL operations) in the pipeline.arrayNo
descriptionDescription of the asset.stringNo
stateCurrent status of the asset. Supported options are: active (asset is active and visible in the environment), inactive (asset is inactive and hidden, serves as a soft delete), hidden (asset is active but hidden in the environment).stringNo