Property description
The activities property adds individual custom SQL operations to a pipeline.
Minimal JSON
{
"key": "",
"name": "",
"type": "",
"statement": ""
}{
"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
| Property | Description | Values | Mandatory |
|---|---|---|---|
key | Unique key of the asset. Used for referencing in the same package or other packages using packageKey#assetKey. | string | Yes |
name | Name of the asset, used as the default EN translation. | string | Yes |
type | Type of the activity. Supported options are: sql_procedure: Executes a stored procedure., sql_query: Runs a single SQL query., sql_script: Executes a full SQL script. | string | Yes |
statement | SQL procedure, script, or query to be executed. | array | Yes |
description | Description of the asset. | string | No |
executionOrderNumber | Execution order of the activity within the pipeline. | integer | No |
isReturningData | Indicates if data is expected. Differentiates between result-producing queries (e.g., SELECT) and action queries (e.g., INSERT, UPDATE, DELETE). | boolean | No |
parameters | Input parameters. | string | No |
runInTransaction | Determines whether the statements execute within a transaction. | boolean | No |