Pipeline table¶
This table defines actual pipelines that use the pipelines templates built and that are going to be deployed in the Azure Data Factory service.
| Column | Description | Format | Required |
|---|---|---|---|
| Id | Identifier of the pipeline | int | Yes |
| ItemId | The global identifier of the pipeline. It is unique within all the pipelines in all the Sidra installations | uniqueidentifier | Yes |
| Name | Name of the pipeline | varchar(80) | Yes |
| ValidFrom | Indicates the date the pipeline starts working | date | Yes |
| ValidUntil | Indicates the date the pipeline should not continue working | date | |
| IdTemplate | Specifies what template is used by this pipeline | int | Yes |
| LastUpdated | Indicates the last update date. If newer than LastDeployed, the pipeline will redeploy on the next Data Factory Manager run | datetime2(0) | Yes |
| LastDeployed | Tells the last date the pipeline has been deployed | datetime2(0) | |
| IdDataFactory | Tells what Data Factory this pipeline must be deployed on | int | Yes |
| IsRemoved | Tells if the Data Factory Manager should remove this pipeline from Azure Data Factory | bit | Yes |
| Parameters | A JSON structure that contains key-value pairs. The keys are placeholder names and the value is the default value to replace placeholder | nvarchar(max) | |
| IdDataIntakeProcess | Data Intake Process identifier | int |