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 | Tells the last date the pipeline has been updated. If its value is greater than LastDeployed, the pipeline will be deployed to Azure Data Factory next time the Data Factory Manager is executed | 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 |